aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Modify interactions between sinval.c and sinvaladt.c. The code that actuallyAlvaro Herrera2008-03-16
| | | | | | | | deals with the queue, including locking etc, is all in sinvaladt.c. This means that the struct definition of the queue, and the queue pointer, are now internal "implementation details" inside sinvaladt.c. Per my proposal dated 25-Jun-2007 and followup discussion.
* Some cleanups of enum-guc code, per comments from Tom.Magnus Hagander2008-03-16
|
* Change hash index creation so that rather than always establishing exactlyTom Lane2008-03-15
| | | | | | | | | | | two buckets at the start, we create a number of buckets appropriate for the estimated size of the table. This avoids a lot of expensive bucket-split actions during initial index build on an already-populated table. This is one of the two core ideas of Tom Raney and Shreya Bhargava's patch to reduce hash index build time. I'm committing it separately to make it easier for people to test the effects of this separately from the effects of their other core idea (pre-sorting the index entries by bucket number).
* Fix inappropriately-timed memory context switch in autovacuum_do_vac_analyze.Tom Lane2008-03-14
| | | | | | This accidentally failed to fail before 8.3, because the context we were switching back to was long-lived anyway; but it sure looks risky as can be now. Well spotted by Pavan Deolasee.
* Fix duplicate word, per Guillaume Lelarge.Alvaro Herrera2008-03-14
|
* Fix vacuum so that autovacuum is really not cancelled when doing an emergencyAlvaro Herrera2008-03-14
| | | | | | job (i.e. to prevent Xid wraparound problems.) Bug reported by ITAGAKI Takahiro in 20080314103837.63D3.52131E4D@oss.ntt.co.jp, though I didn't use his patch.
* Update release notes for 8.3.1 and 8.2.7 releases.Tom Lane2008-03-13
|
* Update to tzdata 2008a distribution (Chilean DST law change).Tom Lane2008-03-13
|
* Fix varstr_cmp's special case for UTF8 encoding on Windows so that stringsTom Lane2008-03-13
| | | | | | | | | | | | that are reported as "equal" by wcscoll() are checked to see if they really are bitwise equal, and are sorted per strcmp() if not. We made this happen a couple of years ago in the regular code path, but it unaccountably got left out of the Windows/UTF8 case (probably brain fade on my part at the time). As in the prior set of changes, affected users may need to reindex indexes on textual columns. Backpatch as far as 8.2, which is the oldest release we are still supporting on Windows.
* Fix heap_page_prune's problem with failing to send cache invalidationTom Lane2008-03-13
| | | | | | | | | | | messages if the calling transaction aborts later on. Collapsing out line pointer redirects is a done deal as soon as we complete the page update, so syscache *must* be notified even if the VACUUM FULL as a whole doesn't complete. To fix, add some functionality to inval.c to allow the pending inval messages to be sent immediately while heap_page_prune is still running. The implementation is a bit chintzy: it will only work in the context of VACUUM FULL. But that's all we need now, and it can always be extended later if needed. Per my trouble report of a week ago.
* Add URL for:Bruce Momjian2008-03-13
| | | | | | | | | * Do async I/O for faster random read-ahead of data Async I/O allows multiple I/O requests to be sent to the disk with results coming back asynchronously. > http://archives.postgresql.org/pgsql-performance/2007-09/msg00255.php
* Fix pg_plan_queries() to restore the previous setting of ActiveSnapshotTom Lane2008-03-12
| | | | | | | | | | | (probably NULL) before exiting. Up to now it's just left the variable as it set it, which means that after we're done processing the current client message, ActiveSnapshot is probably pointing at garbage (because this function is typically run in MessageContext which will get reset). There doesn't seem to have been any code path in which that mattered before 8.3, but now the plancache module might try to use the stale value if the next client message is a Bind for a prepared statement that is in need of replanning. Per report from Alex Hunsaker.
* Add psql TODO:Bruce Momjian2008-03-12
| | | | | | < * Include the symbolic SQLSTATE name in verbose error reports < < http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php
* Add to TODO:Bruce Momjian2008-03-12
| | | | | | > * Expire published xmin for read-only and idle transactions > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00343.php
* Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponingTom Lane2008-03-12
| | | | | | | | | | | | | | | | | | pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk of deadlock than there was before. Aside from fixing the race condition, this gets rid of a truly ugly kludge that was there before, namely having to ignore HeapTupleBeingUpdated failures during NOTIFY. There is a small potential incompatibility, which is that if a transaction issues LISTEN or UNLISTEN and then looks into pg_listener before committing, it won't see any resulting row insertion or deletion, where before it would have. It seems unlikely that anyone would be depending on that, though. This patch also disallows LISTEN and UNLISTEN inside a prepared transaction. That case had some pretty undesirable properties already, such as possibly allowing pg_listener entries to be made for PIDs no longer present, so disallowing it seems like a better idea than trying to maintain the behavior.
* Add:Bruce Momjian2008-03-12
| | | | | | | > > * Consider a special data type for regular expressions > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php
* Back out text search change to TODO.Bruce Momjian2008-03-12
|
* 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 a comment explaining one of the ways that pgbench fails to fullyTom Lane2008-03-12
| | | | comply with TPC-B. Per Itagaki Takahiro and discussion of bug#3681.
* 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 >
* Prevent psql \copy from accepting multiple string parameters, e.g.Bruce Momjian2008-03-11
| | | | | | | | test=> \copy billing_data from ../BillingSamplePricerFile.csv with csv header quote as '"' null as 'abc' null as '123' \copy: parse error at "null" Per report from Stephen Frost
* 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
* Make TransactionIdIsInProgress check transam.c's single-item XID status cacheTom Lane2008-03-11
| | | | | | | | before it goes groveling through the ProcArray. In situations where the same recently-committed transaction ID is checked repeatedly by tqual.c, this saves a lot of shared-memory searches. And it's cheap enough that it shouldn't hurt noticeably when it doesn't help. Concept and patch by Simon, some minor tweaking and comment-cleanup by Tom.
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 04:55:17 +0000