- 13 4月, 2007 5 次提交
-
-
由 Magnus Hagander 提交于
ITAGAKI Takahiro
-
由 Neil Conway 提交于
EXPLAIN ANALYZE can sometimes be significantly slower than running the same query normally, and make some minor markup improvements.
-
由 Neil Conway 提交于
ref page (sorry, my fault!), and simplify the coding of ResetTempTableNamespace().
-
由 Bruce Momjian 提交于
> * -Add RESET SESSION command to reset all session state
-
由 Tom Lane 提交于
fast flow of new fsync requests can prevent mdsync() from ever completing. This was an unforeseen consequence of a patch added in Mar 2006 to prevent the fsync request queue from overflowing. Problem identified by Heikki Linnakangas and independently by ITAGAKI Takahiro; fix based on ideas from Takahiro-san, Heikki, and Tom. Back-patch as far as 8.1 because a previous back-patch introduced the problem into 8.1 ...
-
- 12 4月, 2007 6 次提交
-
-
由 Tom Lane 提交于
report from David Darville. Back-patch as far as 8.1, which may or may not have the problem but it seems a safe change anyway.
-
由 Magnus Hagander 提交于
-
由 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 2 次提交
-
-
由 Bruce Momjian 提交于
output to match.
-
由 Magnus Hagander 提交于
with errorlevel 1 is >= 1 checks failed.
-