- 05 Sep, 2003 9 commits
-
-
Bruce Momjian authored
-- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
-
Bruce Momjian authored
Andrew Dunstan
-
Bruce Momjian authored
> * Maintain a map of recently-expired of pages so vacuum can reclaim > free space without a sequential scan
-
Bruce Momjian authored
-
Bruce Momjian authored
> * -Improve concurrency of hash indexes (Tom)
-
Bruce Momjian authored
platform. Andreas Pflug
-
Bruce Momjian authored
-
Bruce Momjian authored
> o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
-
Bruce Momjian authored
< > * Print table names with constraint names in error messages, or make constraint > names unique within a schema
-
- 04 Sep, 2003 7 commits
-
-
Tom Lane authored
pghackers. This fixes the problem recently reported by Markus KrÌutner (hash bucket split corrupts the state of scans being done concurrently), and I believe it also fixes all the known problems with deadlocks in hash index operations. Hash indexes are still not really ready for prime time (since they aren't WAL-logged), but this is a step forward.
-
Tom Lane authored
grantees.
-
Tom Lane authored
-
Tom Lane authored
-
Bruce Momjian authored
administrator has not turned it on, and fix other PGC_USERLIMIT variables.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 03 Sep, 2003 14 commits
-
-
Bruce Momjian authored
> * Allow to_char to print localized month names (Karel)
-
Bruce Momjian authored
-
Peter Eisentraut authored
bound is valid but does nothing. suggested by Richard Huxton <dev@archonet.com>
-
Peter Eisentraut authored
accordingly.
-
Bruce Momjian authored
* -Have standalone backend read postgresql.conf (Tom)
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
Ian Barwick
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Tom Lane authored
From Karel Zak.
-
- 02 Sep, 2003 6 commits
-
-
Tom Lane authored
killed items; just skip to the next item immediately. Only check for key equality when we reach a non-killed item or the end of the index page. This saves key comparisons when there are lots of killed items, as for example in a heavily-updated table that's not been vacuumed lately. Seems to be a win for pgbench anyway.
-
Peter Eisentraut authored
-
Tom Lane authored
config file if it exists. This was already discussed as being a good idea, and now seems the cleanest way to deal with initdb-time failures on machines with small SHMMAX. (The submitted patches instead modified initdb.sh to pass the correct sizing parameters, but that would still leave standalone backends prone to failure later. An admin who needs to use a standalone backend has enough trouble already, he shouldn't have to manually configure its shmem settings...)
-
Tom Lane authored
layout; therefore, this change forces REINDEX of hash indexes (though not a full initdb). Widen hashm_ntuples to double so that hash space management doesn't get confused by more than 4G entries; enlarge the allowed number of free-space-bitmap pages; replace the useless bshift field with a useful bmshift field; eliminate 4 bytes of wasted space in the per-page special area.
-
Tom Lane authored
-
Tom Lane authored
scheme. A pleasant side effect is that it is *much* faster when deleting a large fraction of the indexed tuples, because of elimination of redundant hash_step activity induced by hash_adjscans. Various other continuing code cleanup.
-
- 01 Sep, 2003 4 commits
-
-
Peter Eisentraut authored
libpq, talking to an old server, should assume SQL_ASCII as the default client encoding, because that is what the server will actually use (not the server encoding).
-
Peter Eisentraut authored
unneeded configure work.
-
Tom Lane authored
yet). Fix a couple of bugs that would only appear if multiple bitmap pages are used, including a buffer reference leak and incorrect computation of bit indexes. Get rid of 'overflow address' concept, which accomplished nothing except obfuscating the code and creating a risk of failure due to limited range of offset field. Rename some misleadingly-named fields and routines, and improve documentation.
-
Tom Lane authored
explanation of the remarkably confusing page addressing scheme. The file also includes my planned-but-not-yet-implemented revision of the hash index locking scheme.
-