- 01 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Make log_min_duration_statement output when the duration is reached rather > than when the statement completes > > This prints long queries while they are running, making trouble shooting > easier. Also, it eliminates the need for log_statement because it > would now be the same as a log_min_duration_statement of zero.
-
- 30 11月, 2004 5 次提交
-
-
由 Bruce Momjian 提交于
< you would like to work on an item, please read the developer's FAQ > you would like to work on an item, please read the Developer's FAQ
-
由 Bruce Momjian 提交于
9c5 < Last updated: Mon Nov 29 23:33:09 EST 2004 > Last updated: Tue Nov 30 00:03:37 EST 2004 13a10,16 > #A hyphen, "-", marks changes that will appear in the upcoming 8.1 release.# > > Bracketed items, "[]", have more detail. > > This list contains all known PostgreSQL bugs and feature requests. If > you would like to work on an item, please read the developer's FAQ > first.
-
由 Bruce Momjian 提交于
> * Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr
-
由 Bruce Momjian 提交于
> o Allow COPY FROM ... CVS to interpret newlines and carriage > returns in data? > > This would require major refactoring of the copy source code.
-
由 Bruce Momjian 提交于
> * Improve NLS maintenace of libpgport messages linked onto applications >
-
- 29 11月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< > * Allow cross-compiling by generating the zic database on the target system
-
由 Bruce Momjian 提交于
> * Auto-vacuum > o Move into the backend code > o Scan the buffer cache to find free space or use background writer > o Use free-space map information to guide refilling
-
- 28 11月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< information, either by name or offset from UTC > information, either zone name or offset from UTC > > If the TIMESTAMP value is stored with a time zone name, interval > computations should adjust based on the time zone rules, e.g. adding > 24 hours to a timestamp would yield a different result from adding one > day. >
-
- 13 11月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS when < not doing WAL archiving > * Eliminate WAL logging for CREATE TABLE AS when not doing WAL archiving
-
由 Bruce Momjian 提交于
> * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS when > not doing WAL archiving
-
- 11 11月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> 284d284 < 286a287 > 405a407 > 415a418 > 431a435 > 440a445 > 452a458 > 520c526 < * ECPG (?) > * ECPG 846a853 > 857a865 >
-
由 Bruce Momjian 提交于
< * Allow GRANT/REVOKE permissions to be given to all schema objects with one > * Allow GRANT/REVOKE permissions to be applied to all schema objects with one 60c60 < specifications. This is because new databases are created by copying > specifications. This is because new databases are created by copying 63c63 < directory would create a new database with tables that had incorrect > directory would create a new database with tables that had incorrect 72c72 < > 85c85 < By not showing commented-out variables, we discourage people from > By not showing commented-out variables, we discourage people from 91c91 < * Allow point-in-time recovery to archive partially filled write-ahead > * Allow point-in-time recovery to archive partially filled write-ahead 102c102 < Currently all schemas are owned by the super-user because they are > Currently all schemas are owned by the super-user because they are 128c128 < * Allow INET subnet tests with non-constants to be indexed > * Allow INET subnet tests using non-constants to be indexed 143,144c143,144 < * Allow to_char to print localized month names < * Allow functions to have a search path specified at creation time > * Allow to_char() to print localized month names > * Allow functions to have a schema search path specified at creation time 146c146 < * Add GUC variable to allow output of interval values in ISO8601 format > * Add a GUC variable to allow output of interval values in ISO8601 format 154,155c154,155 < * Prevent inet cast to cidr if the unmasked bits are not zero, or < zero bits > * Prevent INET cast to CIDR if the unmasked bits are not zero, or > zero the bits 158c158 < o Allow nulls in arrays > o Allow NULLs in arrays 160,161c160,161 < o Delay resolution of array expression type so assignment coercion < can be performed on empty array expressions > o Delay resolution of array expression's data type so assignment > coercion can be performed on empty array expressions 218,219c218,219 < key, foreign key [inheritance] < * UNIQUE INDEX on base column not honored on inserts/updates from > key, foreign key > * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from 221c221 < (dup) should fail [inheritance] > (dup) should fail 246c246 < * Fetch heap pages matching index entries in sequential order [performance] > * Fetch heap pages matching index entries in sequential order 307c307 < functionality in DELETE. It's been agreed that the keyword should > functionality in DELETE. It's been agreed that the keyword should 318c318 < * Allow PREPARE to automatically determine parameter types based on the SQL > * Allow PREPARE to automatically determine parameter types based on the SQL 340,342d339 < * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work < by searching for non-conflicting constraint names, and prefix with < table name? 347c344 < new database. > a new database. 350,351d346 < * Ignore temporary tables from other sessions when processing < inheritance? 354,355c349,351 < * Add a session mode to warn about non-standard SQL usage in queries < * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, triggers?) > * Add a GUC variable to warn about non-standard SQL usage in queries > * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, > triggers?) 357,359c353,356 < * Add NOVICE output level for helpful messages like automatic sequence/index creation < * Add COMMENT ON for all cluster global objects (users, groups, < databases and tablespaces) > * Add NOVICE output level for helpful messages like automatic sequence/index > creation > * Add COMMENT ON for all cluster global objects (users, groups, databases > and tablespaces) 363c360 < When enabled, this would allow errors in multi-statement transactions > When enabled, this would allow errors in multi-statement transactions 417c414 < o Allow COPY to optionally include column headings as the first line > o Allow COPY to optionally include column headings in the first line 450c447 < > 462c459 < o Handle references to temporary tables that are created, destroyed, > o Handle references to temporary tables that are created, destroyed, 464c461 < > 469d465 < o Improve PL/PgSQL exception handling using savepoints 488c484 < > 503d498 < 518c513 < o Add pg_dumpall custom format dumps. > o Add pg_dumpall custom format dumps. 520c515 < This is probably best done by combining pg_dump and pg_dumpall > This is probably best done by combining pg_dump and pg_dumpall 532d526 < o Improve error handling (?) 555c549 < Adding shared locks requires recording the table/rows numbers in a > Adding shared locks requires recording the table/rows numbers in a 643c637 < Posix_fadvise() can control both sequential/random file caching and > Posix_fadvise() can control both sequential/random file caching and 703c697 < from distributted.net, http://www1.distributed.net/source, > from distributted.net, http://www1.distributed.net/source, 729c723 < * Add connection pooling [pool] > * Add connection pooling 755d748 < 759c752 < > 768c761 < so an abrupt operating system restart might lose a few seconds of > so an abrupt operating system restart might lose a few seconds of 785c778 < * Add utility to compute accurate random_page_cost value > * Create utility to compute accurate random_page_cost value 787,789d779 < * Allow sorting, temp files, temp tables to use multiple work directories < < This allows the I/O load to be spread across multiple disk drives. 795a786 > 808,809c799,800 < < * Use mmap() rather than SYSV shared memory or to write WAL files (?) [mmap] > > * Use mmap() rather than SYSV shared memory or to write WAL files (?) 812,813c803,804 < portability issues. Anonymous mmap (or mmap to /dev/zero) is required < to prevent I/O overhead. > portability issues. Anonymous mmap (or mmap to /dev/zero) is required > to prevent I/O overhead. 817,819c808,810 < Doing I/O to large tables would consume a lot of address space or < require frequent mapping/unmapping. Extending the file also causes < mapping problems that might require mapping only individual pages, > Doing I/O to large tables would consume a lot of address space or > require frequent mapping/unmapping. Extending the file also causes > mapping problems that might require mapping only individual pages, 821c812 < way to _prevent_ I/O to disk from the dirty shared buffers so changes > way to _prevent_ I/O to disk from the dirty shared buffers so changes 826c817 < tuple overhead > per-tuple overhead 829,831c820,822 < This would involve using multiple threads or processes to do optimization, < sorting, or execution of single query. The major advantage of such a < feature would be to allow multiple CPUs to work together to process a > This would involve using multiple threads or processes to do optimization, > sorting, or execution of single query. The major advantage of such a > feature would be to allow multiple CPUs to work together to process a 834c825 < * Research the use of larger pages sizes > * Research the use of larger page sizes 842a834 > * Move some /contrib modules out to their own project sites 845d836 < * Improve access-permissions check on data directory in Cygwin (Tom) 847,848c838 < * Clarify use of 'application' and 'command' tags in SGML docs < * Better document ability to build only certain interfaces (Marc) > * Improve documentation to build only interfaces (Marc) 852,853d841 < * Research interaction of setitimer() and sleep() used by statement_timeout < * Rename /scripts directory because they are all C programs now 856,857d843 < * Allow binaries to be statically linked so they are more easily relocated < * Move some /contrib modules out to their own project sites 862c848 < o Remove per-backend parameter file and move into shared memory? > o Remove per-backend parameter file and move into shared memory 877,878c863,864 < o Update clients to use data types, typmod, schema.table.column names of < result sets using new query protocol > o Update clients to use data types, typmod, schema.table.column names > of result sets using new query protocol 900d885 < * Kris is Kris Jurka 910c895 < * Simon is Simon Riggs > * Simon is Simon Riggs <simon@2ndquadrant.com> 913d897 < * Teodor is
-
- 10 11月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
< < * psql tab completion < < o Provide a list of conversions after ALTER CONVERSION? < o Support for ALTER SEQUENCE clauses < o Add RENAME TO to ALTER TRIGGER < o Support for ALTER USER < o Fix ALTER (GROUP|DOMAIN|...) <sth> DROP < o Support for ALTER LANGUAGE <sth> RENAME TO < o Improve support for COPY < o Improve support for ALTER TABLE
-
由 Bruce Momjian 提交于
< heap page to find matching rows. > heap page to find matching rows, or perhaps use a mixed solution where > tids are recorded for pages with only a few matches and per-page bitmaps > are used for more dense pages. Another idea is to use a 32-bit bitmap > for every page and set a bit based on the item number mod(32).
-
由 Bruce Momjian 提交于
> > * Research the use of larger pages sizes
-
- 09 11月, 2004 4 次提交
-
-
由 Bruce Momjian 提交于
< Such indexes could be more compact if there are only a few unique values. > Such indexes could be more compact if there are only a few distinct values. > Such indexes can also be compressed. Keeping such indexes updated can be > costly.
-
由 Bruce Momjian 提交于
< Such indexes could be more compact if there are few unique value. > Such indexes could be more compact if there are only a few unique values.
-
由 Bruce Momjian 提交于
< portability issues. Anonymous mmap is required to prevent I/O < overhead. > portability issues. Anonymous mmap (or mmap to /dev/zero) is required > to prevent I/O overhead. > > * Consider mmap()'ing files into a backend? > > Doing I/O to large tables would consume a lot of address space or > require frequent mapping/unmapping. Extending the file also causes > mapping problems that might require mapping only individual pages, > leading to thousands of mappings. Another problem is that there is no > way to _prevent_ I/O to disk from the dirty shared buffers so changes > could hit disk before WAL is written.
-
由 Bruce Momjian 提交于
< posix_fadvise() [fadvise] > posix_fadvise() > > Posix_fadvise() can control both sequential/random file caching and > free-behind behavior, but it is unclear how the setting affects other > backends that also have the file open, and the feature is not supported > on all operating systems. >
-
- 08 11月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * CREATE TABLE AS can not determine column lengths from expressions [atttypmod] > * Allow CREATE TABLE AS to determine column lengths for complex > expressions like SELECT col1 || col2
-
由 Bruce Momjian 提交于
< * Automatically create rules on views so they are updateable, per SQL99 [view] > * Automatically create rules on views so they are updateable, per SQL99 > > We can only auto-create rules for simple views. For more complex > cases users will still have to write rules. >
-
- 06 11月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
* Allow database recovery where tablespaces can't be created When a pg_dump is restored, all tablespaces will attempt to be created in their original locations. If this fails, the user must be able to adjust the restore process.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 05 11月, 2004 6 次提交
-
-
由 Bruce Momjian 提交于
< one column or expression indexes, perhaps using per=index statistics > one column or expression indexes, perhaps using per-index statistics
-
由 Bruce Momjian 提交于
< * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality > * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() > functionality 278c279 < one column > one column or expression indexes, perhaps using per=index statistics 846a848 > * Remove kerberos4 from source tree?
-
由 Bruce Momjian 提交于
> > * Add fillfactor to control reserved free space during index creation
-
由 Bruce Momjian 提交于
> * Allow accurate statistics to be collected on indexes with more than > one column
-
由 Bruce Momjian 提交于
< that can spam more than one table. > that can span more than one table. 239c239 < rather than just col1 > rather than just col1; also called skip-scanning. 641c641,642 < * Add free-behind capability for large sequential scans [fadvise] > * Allow free-behind capability for large sequential scans, perhaps using > posix_fadvise() [fadvise]
-
由 Bruce Momjian 提交于
< * Allow the creation of bitmap indexes which can be quickly combined < with other bitmap indexes > * Allow non-bitmap indexes to be combined by creating bitmaps in memory 259,261c258,259 < combined. Such indexes could be more compact if there are few unique < value. Also, perhaps they can be lossy requiring a scan of the heap page < to find matching rows. > combined. They can index by tid or can be lossy requiring a scan of the > heap page to find matching rows. 263c261,262 < * Allow non-bitmap indexes to be combined > * Allow the creation of on-disk bitmap indexes which can be quickly > combined with other bitmap indexes 265,266c264 < Do lookups on non-bitmap indexes and create bitmaps in memory that can be < combined with other indexes. > Such indexes could be more compact if there are few unique value.
-
- 04 11月, 2004 5 次提交
-
-
由 Bruce Momjian 提交于
< * Use bitmaps to combine existing indexes [performance] > * Allow the creation of bitmap indexes which can be quickly combined > with other bitmap indexes 255,257c256,266 < Bitmap indexes allow single indexed columns to be combined to < dynamically create a composite index to match a specific query. Each < index is a bitmap, and the bitmaps are AND'ed or OR'ed to be combined. > Bitmap indexes index single columns that can be combined with other bitmap > indexes to dynamically create a composite index to match a specific query. > Each index is a bitmap, and the bitmaps are bitwise AND'ed or OR'ed to be > combined. Such indexes could be more compact if there are few unique > value. Also, perhaps they can be lossy requiring a scan of the heap page > to find matching rows. > > * Allow non-bitmap indexes to be combined > > Do lookups on non-bitmap indexes and create bitmaps in memory that can be > combined with other indexes.
-
由 Bruce Momjian 提交于
Add the script name to the tmp directory name. Move trap up now that the dir is more unique.
-
由 Bruce Momjian 提交于
< This perhaps should use a round-robin allocation system where several < tablespaces are used in a cycle. The cycle pointer should be global. > It could start with a random tablespace from a supplied list and cycle > through the list.
-
由 Bruce Momjian 提交于
< store heap rows in hashed groups. > store heap rows in hashed groups, perhaps using a user-supplied > hash function.
-
由 Bruce Momjian 提交于
< automatically access the heap data too. > automatically access the heap data too. A third idea would be to > store heap rows in hashed groups.
-
- 02 11月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< * Add a GUC variable to control the tablespace for temporary objects > * Add a GUC variable to control the tablespace for temporary objects and > sort files > > This perhaps should use a round-robin allocation system where several > tablespaces are used in a cycle. The cycle pointer should be global. >
-
- 01 11月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * Add a GUC variable to control temporary and TOAST tablespace usage > * Add a GUC variable to control the tablespace for temporary objects
-
由 Bruce Momjian 提交于
> * Add a GUC variable to control temporary and TOAST tablespace usage
-