[COMMITTERS] pgsql: Fix thinko in autovacuum's test to skip temp tables: want to skip

2006-01-20 Thread Tom Lane
Log Message: --- Fix thinko in autovacuum's test to skip temp tables: want to skip any temp table not only our own process' tables. It's not real important since vacuum.c will skip temp tables anyway, but might as well make the code do what it claims to do. Modified Files: --

[COMMITTERS] pgsql: Fix thinko in autovacuum's test to skip temp tables: want to skip

2006-01-20 Thread Tom Lane
Log Message: --- Fix thinko in autovacuum's test to skip temp tables: want to skip any temp table not only our own process' tables. It's not real important since vacuum.c will skip temp tables anyway, but might as well make the code do what it claims to do. Tags: REL8_1_STABLE Modif

[COMMITTERS] pgsql: Update EXPLAIN wording for GEQO usage.

2006-01-20 Thread Bruce Momjian
Log Message: --- Update EXPLAIN wording for GEQO usage. Tags: REL8_1_STABLE Modified Files: -- pgsql/doc/src/sgml/ref: explain.sgml (r1.35 -> r1.35.6.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/explain.sgml.diff?r1=1.35&r2=1.

[COMMITTERS] pgsql: Update EXPLAIN wording for GEQO usage.

2006-01-20 Thread Bruce Momjian
Log Message: --- Update EXPLAIN wording for GEQO usage. Modified Files: -- pgsql/doc/src/sgml/ref: explain.sgml (r1.35 -> r1.36) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/explain.sgml.diff?r1=1.35&r2=1.36) -

[COMMITTERS] pgsql: Replace bitwise looping with bytewise looping in hemdistsign and

2006-01-20 Thread Tom Lane
Log Message: --- Replace bitwise looping with bytewise looping in hemdistsign and sizebitvec of tsearch2, as well as identical code in several other contrib modules. This provided about a 20X speedup in building a large tsearch2 index ... didn't try to measure its effects for other operati

[COMMITTERS] pgsql: Replace bitwise looping with bytewise looping in hemdistsign and

2006-01-20 Thread Tom Lane
Log Message: --- Replace bitwise looping with bytewise looping in hemdistsign and sizebitvec of tsearch2, as well as identical code in several other contrib modules. This provided about a 20X speedup in building a large tsearch2 index ... didn't try to measure its effects for other operati

[COMMITTERS] pgsql: Add GRANT ON SEQUENCE syntax to support sequence-only

2006-01-20 Thread Bruce Momjian
Log Message: --- Add GRANT ON SEQUENCE syntax to support sequence-only permissions. Continue to support GRANT ON [TABLE] for sequences for backward compatibility; issue warning for invalid sequence permissions. [Backward compatibility warning message.] Add USAGE permission for sequences

[COMMITTERS] pgsql: Repair longstanding bug in slru/clog logic: it is possible for

2006-01-20 Thread Tom Lane
Log Message: --- Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code

[COMMITTERS] pgsql: Repair longstanding bug in slru/clog logic: it is possible for

2006-01-20 Thread Tom Lane
Log Message: --- Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code

[COMMITTERS] pgsql: Repair longstanding bug in slru/clog logic: it is possible for

2006-01-20 Thread Tom Lane
Log Message: --- Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code

[COMMITTERS] pgsql: Repair longstanding bug in slru/clog logic: it is possible for

2006-01-20 Thread Tom Lane
Log Message: --- Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code

[COMMITTERS] pgsql: Repair longstanding bug in slru/clog logic: it is possible for

2006-01-20 Thread Tom Lane
Log Message: --- Repair longstanding bug in slru/clog logic: it is possible for two backends to try to create a log segment file concurrently, but the code erroneously specified O_EXCL to open(), resulting in a needless failure. Before 7.4, it was even a PANIC condition :-(. Correct code