- 12 4月, 2007 4 次提交
-
-
由 Magnus Hagander 提交于
-
由 Neil Conway 提交于
reviewed by Neil Conway. This patch adds the following DDL command variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and DEALLOCATE ALL. RESET SESSION is intended for use by connection pool software and the like, in order to reset a client session to something close to its initial state. Note that while most of these command variants can be executed inside a transaction block (but are not transaction-aware!), RESET SESSION cannot. While this is inconsistent, it is intended to catch programmer mistakes: RESET SESSION in an open transaction block is probably unintended.
-
由 Bruce Momjian 提交于
< o Allow single-byte header storage for arrays > o Allow single-byte header storage for array elements
-
由 Tom Lane 提交于
(original code *always* created a full-page image for the left page, thus leaving the intended savings unrealized), avoid risk of not having enough room on the page during xlog restore, squeeze out another couple bytes in the xlog record, clean up neglected comments.
-
- 10 4月, 2007 5 次提交
-
-
由 Bruce Momjian 提交于
> o Allow single-byte header storage for arrays
-
由 Bruce Momjian 提交于
> o Have WITH CONSTRAINTS also create constraint indexes > http://archives.postgresql.org/pgsql-patches/2007-04/msg00149.php
-
由 Tom Lane 提交于
index types can be reliably distinguished by examining the special space on an index page. Per my earlier proposal, plus the realization that there's no need for btree's vacuum cycle ID to cycle through every possible 16-bit value. Restricting its range a little costs nearly nothing and eliminates the possibility of collisions. Memo to self: remember to make bitmap indexes play along with this scheme, assuming that patch ever gets accepted.
-
由 Bruce Momjian 提交于
* Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00151.php
-
由 Magnus Hagander 提交于
and vacuumdb. ITAGAKI Takahiro, with minor fixes from me.
-
- 08 4月, 2007 8 次提交
-
-
由 Bruce Momjian 提交于
> o -Make CLUSTER preserve recently-dead tuples per MVCC requirements
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tatsuo Ishii 提交于
Patch contributed by Pavan Deolasee. Along with Japanese doc modification by Tatsuo Ishii.
-
由 Bruce Momjian 提交于
> o -Add more logical syntax CLUSTER table USING index;
-
由 Bruce Momjian 提交于
Holger Schurig
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
contrib/pgbuffercache. Greg Smith
-
- 07 4月, 2007 9 次提交
-
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
-
由 Bruce Momjian 提交于
confusion.
-
由 Bruce Momjian 提交于
Michael Fuhr
-
由 Bruce Momjian 提交于
> * -Allow use of indexes to search for NULLs
-
由 Bruce Momjian 提交于
o -Support a smaller header for short variable-length fields
-
由 Tom Lane 提交于
there are some corner cases where this is needed by ruleutils.c for proper display of variables during EXPLAIN.
-
由 Tom Lane 提交于
Teodor Sigaev, with some kibitzing from Tom Lane.
-
由 Tom Lane 提交于
types.
-
- 06 4月, 2007 5 次提交
-
-
由 Andrew Dunstan 提交于
-
由 Tatsuo Ishii 提交于
Smith. Along with Japanese doc updation by Tasuo Ishii. > This patch changes the way pgbench outputs its latency log files so that > every transaction gets a timestamp and notes which transaction type was > executed. It's a one-line change that just dumps some additional > information that was already sitting in that area of code. I also made a > couple of documentation corrections and clarifications on some of the more > confusing features of pgbench. > > It's straightforward to parse log files in this format to analyze what > happened during the test at a higher level than was possible with the > original format. You can find some rough sample code to convert this > latency format into CVS files and then into graphs at > http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm which I'll > be expanding on once I get all my little patches sent in here.
-
由 Tatsuo Ishii 提交于
Also tweak README.pgbench/README.pgbench_jis: Remove history after pgbench was added to PostgreSQL contrib module. Those info was not only redundant since it has already been in CVS log, but also incomplete. -------------------------------------------------------------------------- The attached is a patch to optimize contrib/pgbench using new 8.3 features. - Use DROP IF EXISTS to suppress errors for initial loadings. - Use a combination of TRUNCATE and COPY to reduce WAL on creating the accounts table. Also, there are some cosmetic changes. - Change the output of -v option from "starting full vacuum..." to "starting vacuum accounts..." in reflection of the fact. - Shape duplicated error checks into executeStatement(). There is a big performance win in "COPY with no WAL" feature. Thanks for the efforts! --------------------------------------------------------------------------
-
由 Tom Lane 提交于
right, there seems precious little reason to have a pile of hand-maintained endianness definitions in src/include/port/*.h. Get rid of those, and make the couple of places that used them depend on WORDS_BIGENDIAN instead.
-
由 Tom Lane 提交于
This commit breaks any code that assumes that the mere act of forming a tuple (without writing it to disk) does not "toast" any fields. While all available regression tests pass, I'm not totally sure that we've fixed every nook and cranny, especially in contrib. Greg Stark with some help from Tom Lane
-
- 05 4月, 2007 9 次提交
-
-
由 Bruce Momjian 提交于
output to match.
-
由 Magnus Hagander 提交于
with errorlevel 1 is >= 1 checks failed.
-
由 Magnus Hagander 提交于
of tests. Per Andrew Dunstan.
-
由 Bruce Momjian 提交于
* Reduce WAL traffic so only modified values are written rather than entire rows > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01589.php >
-
由 Bruce Momjian 提交于
installation.
-
由 Andrew Dunstan 提交于
-
由 Bruce Momjian 提交于
<H3 id="item3.7">3.7) What computer hardware should I use?</H3>
-
由 Andrew Dunstan 提交于
-
由 Bruce Momjian 提交于
It removes last remaining casts inside struct definitions. Such usage is bad practice, as it hides problems from compiler. Reason for the cast is popular practice in some circles to define functions as foo(MyObj *) instead of foo(PyObject *) thus avoiding a local variable inside functions and make direct calling easier. As pl/python does not use such style, the casts were unnecessary from the start. Marko Kreen
-