- 02 1月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< the Win32 strcoll() can be used. > the Win32 wcscoll() can be used.
-
由 Bruce Momjian 提交于
< o Disallow encodings like UTF8 which which PostgreSQL supports > o Disallow encodings like UTF8 which PostgreSQL supports 914a915,917 > > To fix UTF8, the data needs to be converted to UTF16 and then > the Win32 strcoll() can be used.
-
- 28 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Improve the background writer > > Allow the background writer to more efficiently write dirty buffers > from the end of the LRU cache and use a clock sweep algorithm to > write other dirty buffers to reduced checkpoint I/O
-
- 21 12月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> * Allow the PITR process to be debugged and data examined
-
由 Bruce Momjian 提交于
> * Allow a warm standby system to also allow read-only queries
-
- 19 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow psql \pset boolean variables to set to fixed values, rather than toggle
-
- 17 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> o Disallow encodings like UTF8 which which PostgreSQL supports > but the operating system does not (already disallowed by > pginstaller)
-
- 14 12月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< o Allow the shared memory address to be configured via GUC
-
由 Bruce Momjian 提交于
< o Remove per-backend parameter file and move into shared memory Add for Win32: > o Allow the shared memory address to be configured via GUC
-
- 13 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> > * Allow the size of the buffer cache used by temporary objects to be > specified as a GUC variable > > Larger local buffer cache sizes requires more efficient handling of > local cache lookups.
-
- 04 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
> * ANALYZE should record a pg_statistic entry for an all-NULL column
-
- 03 12月, 2004 5 次提交
-
-
由 Bruce Momjian 提交于
> * Fix priority ordering of read and write light-weight locks (Neil)
-
由 Bruce Momjian 提交于
< > o Fix problem with shared memory on the Win32 Terminal Server
-
由 Bruce Momjian 提交于
> o Improve dlerror() reporting string
-
由 Bruce Momjian 提交于
> * Allow a warm standby system to also allow read-only queries > > This is useful for checking PITR recovery. >
-
由 Bruce Momjian 提交于
> * Fix psql's display of schema information (Neil)
-
- 02 12月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
> > * Allow FOR UPDATE queries to do NOWAIT locks >
-
由 Bruce Momjian 提交于
> * Allow ecpg to work with MSVC and BCC
-
- 01 12月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
< returns in data? > returns in data
-
由 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.
-
由 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. >
-