aboutsummaryrefslogtreecommitdiff
path: root/doc/src/FAQ
Commit message (Collapse)AuthorAge
...
* Add:Bruce Momjian2008-03-12
| | | | | | | > > * Consider a special data type for regular expressions > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php
* Update TODO:Bruce Momjian2008-03-12
| | | | | | | * Add array_accum() and array_to_set() functions for arrays The standards specify array_agg() and UNNEST. http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php
* Add URL for:Bruce Momjian2008-03-12
| | | | | | * Consider a simplified API for full text searches > http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php
* Add for Win32 TODO:Bruce Momjian2008-03-12
| | | | | | | > > o Convert MSVC build system to remove most batch files > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00961.php
* Add URL for:Bruce Momjian2008-03-12
| | | | | | * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY > http://archives.postgresql.org/pgsql-performance/2007-08/msg00289.php
* Add for Win32 TODO:Bruce Momjian2008-03-12
| | | | | | | | > o Diagnose problem where shared memory can sometimes not be > attached by postmaster children > > http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php >
* Add to TODO:Bruce Momjian2008-03-12
| | | | | | | > > * Remove use of MAKE_PTR and MAKE_OFFSET macros > > http://archives.postgresql.org/pgsql-general/2007-08/msg01510.php
* Add to TODO:Bruce Momjian2008-03-12
| | | | | | | > > * Add array_accum() and array_to_set() functions for arrays > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php
* Add URL for:Bruce Momjian2008-03-12
| | | | | | | | | | | * Improve speed with indexes For large table adjustments during VACUUM FULL, it is faster to cluster or reindex rather than update the index. Also, index updates can bloat the index. > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php
* Add:Bruce Momjian2008-03-12
| | | | | | | | > > * Allow domains to be cast > > http://archives.postgresql.org/pgsql-hackers/2003-06/msg01206.php > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00289.php
* Add:Bruce Momjian2008-03-12
| | | | | | | > > * Consider simplifying how memory context resets handle child contexts > > http://archives.postgresql.org/pgsql-patches/2007-08/msg00067.php
* Add URL for:Bruce Momjian2008-03-12
| | | | > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00082.php
* Add URL for:Bruce Momjian2008-03-12
| | | | | | * Consider increasing NUM_CLOG_BUFFERS > http://archives.postgresql.org/pgsql-performance/2007-08/msg00024.php
* Add URL for:Bruce Momjian2008-03-12
| | | | | | | * Consider increasing NUM_CLOG_BUFFERS > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00030.php >
* Update TODO:Bruce Momjian2008-03-11
| | | | | | | | o Allow COPY in CSV mode to control whether a quoted zero-length string is treated as NULL Currently this is always treated as a zero-length string, which generates an error when loading into an integer column
* add to TODO COPY:Bruce Momjian2008-03-11
| | | | | | | > > o Allow COPY in CSV mode to control whether "" is treated as NULL > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00905.php
* Add to pl/pgsql:Bruce Momjian2008-03-11
| | | | | | | | > > o Improve logic of determining if an identifier is a a > variable or column name > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00436.php
* Add:Bruce Momjian2008-03-11
| | | | | | | > > * Add automated check for invalid C++ source code constructs > > http://archives.postgresql.org/pgsql-patches/2007-07/msg00056.php
* Add:Bruce Momjian2008-03-11
| | | | | | > * Research use of signals and sleep wake ups > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00003.php
* Add:Bruce Momjian2008-03-11
| | | | | | | * Test to see if calling PreallocXlogFiles() from the background writer will help with WAL segment creation latency http://archives.postgresql.org/pgsql-patches/2007-06/msg00340.php
* < * Consider adding buffers the BGW finds reusable to the free listBruce Momjian2008-03-11
| | | | | | | | | > * Consider adding buffers the background writer finds reusable to the > free list > > * Consider wither increasing BM_MAX_USAGE_COUNT improves performance > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg01007.php
* Add URL for:Bruce Momjian2008-03-11
| | | | | | * Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php
* Add:Bruce Momjian2008-03-11
| | | | | | | > o Consider normalizing fractions in postgresql.conf, perhaps > using '%' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00550.php
* Add:Bruce Momjian2008-03-11
| | | | | | > * Consider sorting writes during checkpoint > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00541.php
* Add:Bruce Momjian2008-03-11
| | | | | | | > > * Prefix command-line utilities like createuser with 'pg_' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php
* Add:Bruce Momjian2008-03-11
| | | | | | | | > > * Change memory allocation for multi-byte functions so memory is > allocated inside conversion functions > > Currently we preallocate memory based on worst-case usage.
* Add another URL for:Bruce Momjian2008-03-11
| | | | | | | | | | * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes < > http://archives.postgresql.org/pgsql-general/2007-06/msg00542.php
* Add URL for:Bruce Momjian2008-03-11
| | | | | | | | | | * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes > http://archives.postgresql.org/pgsql-general/2007-05/msg01228.php >
* Add:Bruce Momjian2008-03-11
| | | | | | | | | > > * Consider increasing the number of default statistics target, and > reduce statistics target overhead > > Also consider having a larger statistics target for indexed columns > and expression indexes
* Add:Bruce Momjian2008-03-11
| | | | | | | > > * Consider using a hash for joining to a large IN (VALUES ...) list > > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00450.php
* Add for VACUUM:Bruce Momjian2008-03-11
| | | | | | | > > * Consider a more compact data representation for dead tuples > > http://archives.postgresql.org/pgsql-patches/2007-05/msg00143.php
* Add URL for:Bruce Momjian2008-03-11
| | | | | | | * Fix problem when multiple subtransactions of the same outer transaction hold different types of locks, and one subtransaction aborts > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00773.php
* Add:Bruce Momjian2008-03-11
| | | | | | | > > * Add temporal versions of generate_series() > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg01180.php
* Add for pl/pgsql:Bruce Momjian2008-03-11
| | | | | | | o Review handling of MOVE and FETCH http://archives.postgresql.org/pgsql-patches/2007-04/msg00527.php
* Add:Bruce Momjian2008-03-11
| | | | | | | > o Prevent pg_dump/pg_restore from being affected by > statement_timeout > > Using psql to restore a pg_dump dump is also affected.
* Add:Bruce Momjian2008-03-11
| | | | | > * Allow statistics last vacuum/analyze execution times to be displayed > without requiring stats_row_level to be enabled
* Remove item, per Alvaro:Bruce Momjian2008-03-11
| | | | | | | | < < o Set up autovacuum to ignore statement_timeout set in < postgresql.conf < < http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php
* Add:Bruce Momjian2008-03-11
| | | | | | | | | | | | > > * Consider adding buffers the BGW finds reusable to the free list > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php > > * Automatically tune bgwriter_delay based on activity rather then using a > fixed interval > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php
* Add:Bruce Momjian2008-03-11
| | | | | | | | > > o Set up autovacuum to ignore statement_timeout set in > postgresql.conf > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php
* Add URL for:Bruce Momjian2008-03-11
| | | | | | * Optimize referential integrity checks > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00744.php
* Add URL for:Bruce Momjian2008-03-11
| | | | | | | * Allow administrators to safely terminate individual sessions either via an SQL function or SIGTERM > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00218.php
* Add:Bruce Momjian2008-03-10
| | | | | | | | > > * Consider increasing the minimum allowed number of shared buffers > > http://archives.postgresql.org/pgsql-bugs/2008-02/msg00157.php >
* Add:Bruce Momjian2008-03-08
| | | | | | | | > > * Consider a function-based API for '@@' full text searches > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00511.php >
* Add:Bruce Momjian2008-03-07
| | | | | | | | | > > * Add a function like pg_get_indexdef() that report more detailed index > information > > http://archives.postgresql.org/pgsql-bugs/2007-12/msg00166.php >
* Add:Bruce Momjian2008-03-07
| | | | | | | | | | > > > o Prevent autovacuum from running if an old transaction is still > running from the last vacuum > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00899.php >
* Added to TODO:Bruce Momjian2008-03-07
| | | | | | | > > * Allow text search dictionary to filter out only stop words > > http://archives.postgresql.org/pgsql-patches/2007-11/msg00081.php
* Add to TODO:Bruce Momjian2008-03-07
| | | | | | | | > > * Consider allowing higher priority queries to have referenced buffer > cache pages stay in memory longer > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00562.php
* Add:Bruce Momjian2008-03-07
| | | | | | | > > * Improve referential integrity checks > > http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php
* Add item:Bruce Momjian2008-03-07
| | | | | | | > o Store per-table autovacuum settings in pg_class.reloptions. > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01440.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00724.php
* Add URL for:Bruce Momjian2008-03-07
| | | | | | | * Allow multiple identical NOTIFY events to always be communicated to the client, rather than sent as a single notification to the listener http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 07:39:43 +0000