[COMMITTERS] pgsql: Grab some low-hanging fruit in the new hash index build code.

2008-03-16 Thread Tom Lane
Log Message: --- Grab some low-hanging fruit in the new hash index build code. oprofile shows that a nontrivial amount of time is being spent in repeated calls to index_getprocinfo, which really only needs to be called once. So do that, and inline _hash_datum2hashkey to make it work. Modi

[COMMITTERS] npgsql - Npgsql2: Added support for INTERSECT and EXCEPT.

2008-03-16 Thread User Jbcooley
Log Message: --- Added support for INTERSECT and EXCEPT. Fixed LIMIT when used in joins. Modified Files: -- Npgsql2/src/Npgsql/SqlGenerators: SqlBaseGenerator.cs (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/SqlGener

[COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

2008-03-16 Thread Tom Lane
Log Message: --- Fix TransactionIdIsCurrentTransactionId() to use binary search instead of linear search when checking child-transaction XIDs. This makes for an important speedup in transactions that have large numbers of children, as in a recent example from Craig Ringer. We can also get

[COMMITTERS] pgsql: Done: > o -During index creation, pre-sort the tuples to

2008-03-16 Thread Bruce Momjian
Log Message: --- Done: > o -During index creation, pre-sort the tuples to improve build speed Modified Files: -- pgsql/doc: TODO (r1.2329 -> r1.2330) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2329&r2=1.2330) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Add a note to the CREATE INDEX reference page about the impact of

2008-03-16 Thread Tom Lane
Log Message: --- Add a note to the CREATE INDEX reference page about the impact of maintenance_work_mem and effective_cache_size on index creation speed. Modified Files: -- pgsql/doc/src/sgml/ref: create_index.sgml (r1.66 -> r1.67) (http://anoncvs.postgresq

[COMMITTERS] autodoc - autodoc: 1.31 actual

2008-03-16 Thread User Rbt
Log Message: --- 1.31 actual Modified Files: -- autodoc: ChangeLog (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/ChangeLog.diff?r1=1.6&r2=1.7) -- Sent via pgsql-committers mailing list ([email protected]) To mak

Re: [COMMITTERS] pgsql: Modify interactions between sinval.c and sinvaladt.c.

2008-03-16 Thread Tom Lane
[EMAIL PROTECTED] (Alvaro Herrera) writes: > Modify interactions between sinval.c and sinvaladt.c. The code that actually > deals with the queue, including locking etc, is all in sinvaladt.c. This > means > that the struct definition of the queue, and the queue pointer, are now > internal "imple

[COMMITTERS] pgsql: When creating a large hash index, pre-sort the index entries by

2008-03-16 Thread Tom Lane
Log Message: --- When creating a large hash index, pre-sort the index entries by estimated bucket number, so as to ensure locality of access to the index during the insertion step. Without this, building an index significantly larger than available RAM takes a very long time because of thr

[COMMITTERS] pgsql: Modify interactions between sinval.c and sinvaladt.c.

2008-03-16 Thread Alvaro Herrera
Log Message: --- Modify interactions between sinval.c and sinvaladt.c. The code that actually deals with the queue, including locking etc, is all in sinvaladt.c. This means that the struct definition of the queue, and the queue pointer, are now internal "implementation details" inside sin

[COMMITTERS] pgsql: Some cleanups of enum-guc code, per comments from Tom.

2008-03-16 Thread Magnus Hagander
Log Message: --- Some cleanups of enum-guc code, per comments from Tom. Modified Files: -- pgsql/src/backend/utils/misc: README (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/README?r1=1.8&r2=1.9) guc.c (r1.437