- 22 4月, 2007 7 次提交
-
-
由 Tom Lane 提交于
(it's so nice to have a buildfarm member that actively rejects naked uses of strcasecmp). This coding is still pretty awful, though, since it's going to be O(N^2) in the number of guc variables. May I direct your attention to bsearch?
-
由 Tom Lane 提交于
are mostly excluded by constraints: do the CE test a bit earlier to save some adjust_appendrel_attrs() work on excluded children, and arrange to use array indexing rather than rt_fetch() to fetch RTEs in the main body of the planner. The latter is something I'd wanted to do for awhile anyway, but seeing list_nth_cell() as 35% of the runtime gets one's attention.
-
由 Magnus Hagander 提交于
Joachim Wieland
-
由 Peter Eisentraut 提交于
are removed from the configuration file. Joachim Wieland
-
由 Magnus Hagander 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
library. New configure option --with-ossp-uuid to activate.
-
- 21 4月, 2007 9 次提交
-
-
由 Andrew Dunstan 提交于
-
由 Tom Lane 提交于
will be excluded by constraint exclusion anyway. Greg Stark
-
由 Tom Lane 提交于
child attnums are the same, before it grovels through each and every child column looking for a name match. Saves some time in large inheritance trees, per example from Greg.
-
由 Tom Lane 提交于
values: don't throw away perfectly good hash bits, and increase the shift distances so as to provide more separation in the common case where some of the key values are small integers (and so their hashes are too, because hashfunc.c doesn't try all that hard). This reduces the runtime of SearchCatCache by a factor of 4 in an example provided by Greg Stark, in which the planner spends a whole lot of time searching the two-key STATRELATT cache. It seems unlikely to hurt in other cases, but maybe we could do even better?
-
由 Tom Lane 提交于
when a relation is opened multiple times in the same transaction. This is particularly useful for system catalogs, which we may heap_open or index_open many times in a transaction, and it doesn't really cost anything extra even if the rel is touched but once. Motivated by study of an example from Greg Stark, in which pgstat_initstats() accounted for an unreasonably large fraction of the runtime.
-
由 Tom Lane 提交于
In very large queries this accounts for a noticeable fraction of planning time. Per an example from Greg Stark.
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
multiple releases.
-
- 20 4月, 2007 8 次提交
-
-
由 Bruce Momjian 提交于
checklist.
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
Security: CVE-2007-2138
-
由 Tom Lane 提交于
This is needed to allow a security-definer function to set a truly secure value of search_path. Without it, a malicious user can use temporary objects to execute code with the privileges of the security-definer function. Even pushing the temp schema to the back of the search path is not quite good enough, because a function or operator at the back of the path might still capture control from one nearer the front due to having a more exact datatype match. Hence, disable searching the temp schema altogether for functions and operators. Security: CVE-2007-2138
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
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 提交于
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 提交于
-
- 19 4月, 2007 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Alvaro Herrera 提交于
Riggs, additional code and docs by me. Per discussion.
-
- 18 4月, 2007 11 次提交
-
-
由 Magnus Hagander 提交于
win32.mak file. Enable building with kerberos support using the win32.mak file. Hiroshi Saito + me
-
由 Bruce Momjian 提交于
< o -Add MOVE < o -Add support for SCROLL cursors > o Add support for MOVE and SCROLL cursors
-
由 Magnus Hagander 提交于
Make it possible to set the default from builenv.bat. Per request from Dave Page
-
由 Magnus Hagander 提交于
-
由 Bruce Momjian 提交于
Backpatch doc change to 8.2.X.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
multi-byte value. It can also be a single-byte encoded character if the client and server versions match. Backpatch to 8.2.X.
-
由 Bruce Momjian 提交于
< o -Add support for WITH HOLD and SCROLL cursors > o -Add support for SCROLL cursors > o Add support for WITH HOLD cursors
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
< o Add support for WITH HOLD and SCROLL cursors > o -Add support for WITH HOLD and SCROLL cursors
-
由 Bruce Momjian 提交于
< o Add MOVE > o -Add MOVE
-