- 23 1月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
< BY col {DESC} LIMIT 1. Completing this item involves making this > BY col {DESC} LIMIT 1. Completing this item involves doing this < invalidated if anyone modifies the table. < > invalidated if anyone modifies the table. Another idea is to > get a count directly from a unique index, but for this to be > faster than a sequential scan it must avoid access to the heap > to obtain tuple visibility information. > > * Allow data to be pulled directly from indexes > > Currently indexes do not have enough tuple tuple visibility > information to allow data to be pulled from the index without > also accessing the heap. One way to allow this is to set a bit > to index tuples to indicate if a tuple is currently visible to > all transactions when the first valid heap lookup happens. This > bit would have to be cleared when a heap tuple is expired. >
-
- 22 1月, 2005 1 次提交
-
-
由 Neil Conway 提交于
pass if "default_with_oids" is set to false. I took the approach of explicitly adding WITH OIDS to the CREATE TABLEs where necessary, rather than tweaking the default_with_oids GUC var.
-
- 21 1月, 2005 1 次提交
-
-
由 Neil Conway 提交于
-
- 20 1月, 2005 2 次提交
-
-
由 Neil Conway 提交于
expression types.
-
由 Bruce Momjian 提交于
-
- 19 1月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
> * Add 'tid != tid ' operator for use in corruption recovery
-
由 Neil Conway 提交于
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
(1) Keep a pin on the scan's current buffer and mark buffer. This avoids the need to do a ReadBuffer() for each tuple produced by the scan. Since ReadBuffer() is expensive, this is a significant win. (2) Convert a ReleaseBuffer(); ReadBuffer() pair into ReleaseAndReadBuffer(). Surely not a huge win, but it saves a lock acquire/release... (3) Remove a bunch of duplicated code in rtget.c; make rtnext() handle both the "initial result" and "subsequent result" cases. (4) Add support for index tuple killing (5) Remove rtscancache(): it is dead code, for the same reason that gistscancache() is dead code (an index scan ought not be invoked with NoMovementScanDirection). The end result is about a 10% improvement in rtree index scan perf, according to contrib/rtree_gist/bench.
-
由 Neil Conway 提交于
good style and to satisfy sparse. From Alvaro Herrera.
-
- 18 1月, 2005 8 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Peter Eisentraut 提交于
-
由 PostgreSQL Daemon 提交于
its that time ... tag it for release
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
interval datatypes as well as timestamp.
-
由 Bruce Momjian 提交于
correct. It's in addition to the previous patch. David Fetter
-
- 17 1月, 2005 15 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Neil Conway 提交于
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
an untyped literal in the CASE's test expression. This adds test coverage for a bug that was fixed by Tom on January 12.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
tells what arguments go to pl/perl triggers. David Fetter
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Ian Barwick
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
-
- 16 1月, 2005 4 次提交
-
-
由 Bruce Momjian 提交于
Alvaro
-
由 Bruce Momjian 提交于
Euler Taveira de Oliveira
-
由 Bruce Momjian 提交于
Euler Taveira de Oliveira
-
由 Tom Lane 提交于
-
- 15 1月, 2005 3 次提交
-
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
the right place in the docs, and gettext()ify it.
-