- 19 Apr, 2007 6 commits
-
-
Tom Lane authored
failed (due to lock conflicts or out-of-space). We might have already extended the index's filesystem EOF before failing, causing the EOF to be beyond what the metapage says is the last used page. Hence the invariant maintained by the code needs to be "EOF is at or beyond last used page", not "EOF is exactly the last used page". Problem was created by my patch of 2006-11-19 that attempted to repair bug #2737. Since that was back-patched to 7.4, this needs to be as well. Per report and test case from Vlastimil Krejcir.
-
Tom Lane authored
pass-by-reference data type and the RETURN statement is within an EXCEPTION block. Bug introduced by my fix of 2007-01-28 to use per-subtransaction ExprContexts/EStates; since that wasn't back-patched into older branches, only 8.2 and HEAD are affected. Per report from Gary Winslow.
-
Alvaro Herrera authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 18 Apr, 2007 9 commits
-
-
Bruce Momjian authored
-
Alvaro Herrera authored
Riggs, additional code and docs by me. Per discussion.
-
Magnus Hagander authored
win32.mak file. Enable building with kerberos support using the win32.mak file. Hiroshi Saito + me
-
Bruce Momjian authored
< o -Add MOVE < o -Add support for SCROLL cursors > o Add support for MOVE and SCROLL cursors
-
Magnus Hagander authored
Make it possible to set the default from builenv.bat. Per request from Dave Page
-
Magnus Hagander authored
-
Bruce Momjian authored
Backpatch doc change to 8.2.X.
-
Bruce Momjian authored
-
Bruce Momjian authored
multi-byte value. It can also be a single-byte encoded character if the client and server versions match. Backpatch to 8.2.X.
-
- 17 Apr, 2007 11 commits
-
-
Bruce Momjian authored
< o -Add support for WITH HOLD and SCROLL cursors > o -Add support for SCROLL cursors > o Add support for WITH HOLD cursors
-
Tom Lane authored
-
Bruce Momjian authored
< o Add support for WITH HOLD and SCROLL cursors > o -Add support for WITH HOLD and SCROLL cursors
-
Bruce Momjian authored
< o Add MOVE > o -Add MOVE
-
Bruce Momjian authored
< Currently all schemas are owned by the super-user because they are < copied from the template1 database. > Currently all schemas are owned by the super-user because they are copied > from the template1 database. However, since all objects are inherited > from the template database, it is not clear that setting schemas to the db > owner is correct.
-
Tom Lane authored
doing so can result in crash if an sinval reset occurs meanwhile. I believe this explains intermittent buildfarm failures in cluster test.
-
Bruce Momjian authored
< * %Set proper permissions on non-system schemas during db creation > * Set proper permissions on non-system schemas during db creation
-
Tom Lane authored
competing alternatives for indexes to use in a bitmap scan. The former coding took estimated selectivity as an overriding factor, causing it to sometimes choose indexes that were much slower to scan than ones with a slightly worse selectivity. It was also too narrow-minded about which combinations of indexes to consider ANDing. The rewrite makes it pay more attention to index scan cost than selectivity; this seems sane since it's impossible to have very bad selectivity with low cost, whereas the reverse isn't true. Also, we now consider each index alone, as well as adding each index to an AND-group led by each prior index, for a total of about O(N^2) rather than O(N) combinations considered. This makes the results much less dependent on the exact order in which the indexes are considered. It's still a lot cheaper than an O(2^N) exhaustive search. A prefilter step eliminates all but the cheapest of those indexes using the same set of WHERE conditions, to keep the effective value of N down in scenarios where the DBA has created lots of partially-redundant indexes.
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
-
- 16 Apr, 2007 8 commits
-
-
Magnus Hagander authored
Merlin Moncure
-
Tom Lane authored
Kris Jurka
-
Tom Lane authored
sequence for dumping without also selecting its owning table. Make it not try to emit ALTER SEQUENCE OWNED BY in this situation. Per report from Michael Nolan.
-
Magnus Hagander authored
Per request from Hiroshi Saito.
-
Alvaro Herrera authored
processes to be running simultaneously. Also, now autovacuum processes do not count towards the max_connections limit; they are counted separately from regular processes, and are limited by the new GUC variable autovacuum_max_workers. The launcher now has intelligence to launch workers on each database every autovacuum_naptime seconds, limited only on the max amount of worker slots available. Also, the global worker I/O utilization is limited by the vacuum cost-based delay feature. Workers are "balanced" so that the total I/O consumption does not exceed the established limit. This part of the patch was contributed by ITAGAKI Takahiro. Per discussion.
-
Tom Lane authored
a replan. I had originally thought this was not necessary, but the new SPI facilities create a path whereby queries planned with non-default options can get into the cache, so it is necessary.
-
Tom Lane authored
Pavel Stehule, reworked a bit by Tom.
-
Tom Lane authored
access to the planner's cursor-related planning options, and provide new FETCH/MOVE routines that allow access to the full power of those commands. Small refactoring of planner(), pg_plan_query(), and pg_plan_queries() APIs to make it convenient to pass the planning options down from SPI. This is the core-code portion of Pavel Stehule's patch for scrollable cursor support in plpgsql; I'll review and apply the plpgsql changes separately.
-
- 15 Apr, 2007 4 commits
-
-
Tom Lane authored
possibly be any useful pathkeys --- to wit, queries with neither any join clauses nor any ORDER BY request. It's nearly free to check for this case and it saves a useful fraction of the planning time for simple queries.
-
Andrew Dunstan authored
-
Tatsuo Ishii authored
"Server-side support of all encodings" around 2007/3/26. initdb required.
-
Tatsuo Ishii authored
-
- 14 Apr, 2007 1 commit
-
-
Andrew Dunstan authored
-
- 13 Apr, 2007 1 commit
-
-
Bruce Momjian authored
< o Consider reducing on-disk varlena length from four to two < because a heap row cannot be more than 64k in length > o Consider reducing on-disk varlena length from four bytes to > two because a heap row cannot be more than 64k in length
-