- 16 Jul, 2001 4 commits
-
-
Bruce Momjian authored
-
Tom Lane authored
Note: I didn't force an initdb, figuring that one today was enough. However, there is a new function in pg_proc.h, and pg_dump won't be able to dump partial indexes until you add that function.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 15 Jul, 2001 8 commits
-
-
Tom Lane authored
per previous discussion on pghackers. Most of the duplicate code in different AMs' ambuild routines has been moved out to a common routine in index.c; this means that all index types now do the right things about inserting recently-dead tuples, etc. (I also removed support for EXTEND INDEX in the ambuild routines, since that's about to go away anyway, and it cluttered the code a lot.) The retail indextuple deletion routines have been replaced by a "bulk delete" routine in which the indexscan is inside the access method. I haven't pushed this change as far as it should go yet, but it should allow considerable simplification of the internal bookkeeping for deletions. Also, add flag columns to pg_am to eliminate various hardcoded tests on AM OIDs, and remove unused pg_am columns. Fix rtree and gist index types to not attempt to store NULLs; before this, gist usually crashed, while rtree managed not to crash but computed wacko bounding boxes for NULL entries (which might have had something to do with the performance problems we've heard about occasionally). Add AtEOXact routines to hash, rtree, and gist, all of which have static state that needs to be reset after an error. We discovered this need long ago for btree, but missed the other guys. Oh, one more thing: concurrent VACUUM is now the default.
-
Tom Lane authored
as predictable as it used to be, due to recycling of free space with new VACUUM.
-
Bruce Momjian authored
-
Peter Eisentraut authored
accordingly.
-
Peter Eisentraut authored
absolute paths of the source tree in the po files. Also, run msgfmt with -c option in maintainer-check.
-
Peter Eisentraut authored
-
Tatsuo Ishii authored
* Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes
-
Bruce Momjian authored
null terminated strings. The FE/BE protocol sends in some cases null terminated strings to the client. The docs for the FE/BE protocol state that there is no limit on the size of a null terminated string sent to the client and a client should be coded using an expanding buffer to deal with large strings. The old code did not do this and gave an error if a null terminated string was greater than either 4 or 8K. It appears that with the advent of TOAST very long SQL statements are becoming more common, and apparently some error messages from the backend include the SQL statement thus easily exceeding the 8K limit in the old code. In fixing I also cleaned up some calls in the JDBC fastpath code that were not doing character set conversion under multibyte, and removed some methods that were no longer needed. I also removed a potential threading problem with a shared variable that was being used in Connection.java. Thanks to Steve Wampler for discovering the problem and sending the initial diffs that were the basis of this patch. thanks, --Barry
-
- 13 Jul, 2001 5 commits
-
-
Tom Lane authored
because index locking issues are not handled correctly yet. Need to go work on the index AMs next.
-
Tom Lane authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 12 Jul, 2001 10 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
From Vince Vielhaber.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
validity checking rules for VACUUM. Make some other rearrangements of the VACUUM code to allow more code to be shared between full and lazy VACUUM. Minor code cleanups and added comments for TransactionId manipulations.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 11 Jul, 2001 13 commits
-
-
Bruce Momjian authored
> > for docs, hope he does not mind ;) Marko Kreen
-
Bruce Momjian authored
Christian Ullrich
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
a lie on many Unixen), invoke listen() with MIN(MaxBackends*2, 10000). The clamp value 10000 is configurable in config.h.in, if that proves to be necessary --- hopefully it won't.
-
Bruce Momjian authored
terminology. Also, the function owner is now determined and saved at compile time (no gotchas here, right?)/ Mark Volpe
-
Tom Lane authored
This makes VACUUM work properly with partial indexes, and avoids memory leakage with functional indexes. Also, suppress complaint about fewer index tuples than heap tuples when the index is a partial index. From Martijn van Oosterhout.
-
Bruce Momjian authored
INITIALLY DEFERRED in source code. cf. preproc.y:1455. Unknown.
-
Bruce Momjian authored
-