- 02 12月, 2005 4 次提交
-
-
由 Bruce Momjian 提交于
< be cleared when a heap tuple is expired. Another idea is to maintain < a bitmap of heap pages where all rows are visible to all backends, < and allow index lookups to reference that bitmap to avoid heap < lookups, perhaps the same bitmap we might add someday to determine < which heap pages need vacuuming. > be cleared when a heap tuple is expired. > > Another idea is to maintain a bitmap of heap pages where all rows > are visible to all backends, and allow index lookups to reference > that bitmap to avoid heap lookups, perhaps the same bitmap we might > add someday to determine which heap pages need vacuuming. Frequently > accessed bitmaps would have to be stored in shared memory. One 8k > page of bitmaps could track 512MB of heap pages.
-
由 Bruce Momjian 提交于
< the heap. One way to allow this is to set a bit to index tuples > the heap. One way to allow this is to set a bit on index tuples < be cleared when a heap tuple is expired. < > be cleared when a heap tuple is expired. Another idea is to maintain > a bitmap of heap pages where all rows are visible to all backends, > and allow index lookups to reference that bitmap to avoid heap > lookups, perhaps the same bitmap we might add someday to determine > which heap pages need vacuuming.
-
由 Bruce Momjian 提交于
> [merge] 378a380 > [merge]
-
由 Bruce Momjian 提交于
< * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, < triggers?) > * Add SQL-standard MERGE command, typically used to merge two tables > > This is similar to UPDATE, then for unmatched rows, INSERT. > Whether concurrent access allows modifications which could cause > row loss is implementation independent. > > * Add REPLACE or UPSERT command that does UPDATE, or on failure, INSERT
-
- 29 11月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
< #A hyphen, "-", marks changes that will appear in the upcoming 8.1 release.# > #A hyphen, "-", marks changes that will appear in the upcoming 8.2 release.#
-
由 Bruce Momjian 提交于
< * Remove Win32 rename/unlink looping if unnecessary
-
由 Bruce Momjian 提交于
> * Allow COMMENT ON to accept an expression rather than just a string
-
- 24 11月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< > o Add -f to pg_dumpall
-
- 23 11月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
> o -Allow NULLs in arrays
-
由 Bruce Momjian 提交于
> > * Add estimated_count(*) to return an estimate of COUNT(*) > > This would use the planner ANALYZE statistatics to return an estimated > count.
-
- 17 11月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< so duplicate checking can be easily performed. > so duplicate checking can be easily performed. It is possible to > do it without a unique index if we require the user to LOCK the table > before the MERGE.
-
由 Bruce Momjian 提交于
< * Add a libpq function to support Parse/DescribeStatement capability < * Add PQescapeIdentifier() to libpq < * Prevent PQfnumber() from lowercasing unquoted the column name < < PQfnumber() should never have been doing lowercasing, but historically < it has so we need a way to prevent it < 648a642,661 > > > libpq > > o Add a function to support Parse/DescribeStatement capability > o Add PQescapeIdentifier() > o Prevent PQfnumber() from lowercasing unquoted the column name > > PQfnumber() should never have been doing lowercasing, but > historically it has so we need a way to prevent it > > o Allow query results to be automatically batched to the client > > Currently, all query results are transfered to the libpq > client before libpq makes the results available to the > application. This feature would allow the application to make > use of the first result rows while the rest are transfered, or > held on the server waiting for them to be requested by libpq. > One complexity is that a query like SELECT 1/col could error > out mid-way through the result set.
-
- 16 11月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
> > To implement this cleanly requires that the table have a unique index > so duplicate checking can be easily performed. >
-
- 27 10月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
< o Allow ALTER TABLE RENAME CONSTRAINT > o Add ALTER TABLE RENAME CONSTRAINT, update index name also
-
由 Bruce Momjian 提交于
> o Have ALTER INDEX update the name of a constraint using that index > o Allow ALTER TABLE RENAME CONSTRAINT
-
由 Bruce Momjian 提交于
< o Add a GUC variable to allow output of interval values in ISO8601 < format 212a211,223 > o Add a GUC variable to allow output of interval values in ISO8601 > format > o Improve timestamptz subtraction to be DST-aware > > Currently, subtracting one date from another that crosses a > daylight savings time adjustment can return '1 day 1 hour', but > adding that back to the first date returns a time one hour in > the future. This is caused by the adjustment of '25 hours' to > '1 day 1 hour', and '1 day' is the same time the next day, even > if daylight savings adjustments are involved. > > o Fix interval display to support values exceeding 2^31 hours > o Add overflow checking to timestamp and interval arithmetic
-
- 26 10月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
> > o Add auto-expanded mode so expanded output is used if the row > length is wider than the screen width. > > Consider using auto-expanded mode for backslash commands like \df+.
-
- 25 10月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow user-defined functions retuning a domain value to enforce domain > constraints
-
- 13 10月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
> * Prevent PQfnumber() from lowercasing unquoted the column name > > PQfnumber() should never have been doing lowercasing, but historically > it has so we need a way to prevent it >
-
由 Bruce Momjian 提交于
< * Prevent libpq's PQfnumber() from lowercasing the column name < < One idea is to lowercase all identifiers except those that are < surrounded by quotes. <
-
- 12 10月, 2005 7 次提交
-
-
由 Bruce Momjian 提交于
< < * Add code to detect an SMP machine and handle spinlocks accordingly < from distributted.net, http://www1.distributed.net/source, < in client/common/cpucheck.cpp < < On SMP machines, it is possible that locks might be released shortly, < while on non-SMP machines, the backend should sleep so the process < holding the lock can complete and release it.
-
由 Bruce Momjian 提交于
< o %Add dumping of comments on composite type columns < o %Add dumping of comments on index columns < o Stop dumping CASCADE on DROP TYPE commands in clean mode > o %Add dumping of comments on index columns and composite type columns 604a603 > o Stop dumping CASCADE on DROP TYPE commands in clean mode
-
由 Bruce Momjian 提交于
< o %Replace crude DELETE FROM method of pg_dumpall --clean for < cleaning of roles with separate DROP commands 608a607 >
-
由 Bruce Momjian 提交于
< > o Allow pg_dump --clean to drop roles that own objects or have > privileges
-
由 Bruce Momjian 提交于
< * Prevent libpq's PQfnumber() from lowercasing the column name? > * Prevent libpq's PQfnumber() from lowercasing the column name > > One idea is to lowercase all identifiers except those that are > surrounded by quotes. >
-
由 Bruce Momjian 提交于
> o Add options like pg_restore -l and -L to pg_dump
-
由 Bruce Momjian 提交于
> o Allow selection of individual object(s) of all types, not just > tables > o In a selective dump, allow dumping of an object and all its > dependencies
-
- 07 10月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< * Consider compressing indexes by storing key prefix values shared by > * Consider compressing indexes by storing key values duplicated in 735a736,737 > > This is difficult because it requires datatype-specific knowledge.
-
由 Bruce Momjian 提交于
< > * Consider compressing indexes by storing key prefix values shared by > several rows as a single index entry
-
- 03 10月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< * -Have sequence dependency track use of DEFAULT sequences
-
由 Bruce Momjian 提交于
< * Have sequence dependency track use of DEFAULT sequences, < seqname.nextval? > * -Have sequence dependency track use of DEFAULT sequences
-
- 28 9月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
< * +Add options to pg_config to show the share_dir, sysconfdir, < pkgincludedir, and localedir
-
- 27 9月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
> o Improve signal handling, > http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php
-
由 Bruce Momjian 提交于
< * Add options to pg_config to show the share_dir, sysconfdir, > * +Add options to pg_config to show the share_dir, sysconfdir,
-
- 26 9月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< * Allow protocol-level EXECUTE that is actually a fetch to appear < in the logs as a fetch rather than another execute
-
由 Bruce Momjian 提交于
> * Allow protocol-level BIND parameter values to be logged > * Allow protocol-level EXECUTE that is actually a fetch to appear > in the logs as a fetch rather than another execute
-
- 24 9月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
> * Simplify dropping roles that have objects in several databases
-
由 Bruce Momjian 提交于
> o Allow PL/PgSQL to support WITH HOLD cursors
-
由 Bruce Momjian 提交于
> > o Display IN, INOUT, and OUT parameters in \df+ > > It probably requires psql to output newlines in the proper > column, which is already on the TODO list.
-