Re: [COMMITTERS] pgsql: Add: > * Add tool to query pg_stat_* tables

2005-04-19 Thread Fabien COELHO
Hello, * Add tool to query pg_stat_* tables and report indexes that aren't needed or tables that might need indexes Good. This is the kind of things I'm planning for the "pg-advisor" tool, which queries system relations thru views and report inconsistencies (such as mismatching types for foreig

[COMMITTERS] pgsql: Add: > * Add tool to query pg_stat_* tables and report indexes

2005-04-19 Thread Bruce Momjian
Log Message: --- Add: > * Add tool to query pg_stat_* tables and report indexes that aren't needed > or tables that might need indexes Modified Files: -- pgsql/doc: TODO (r1.1499 -> r1.1500) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff

[COMMITTERS] pgsql: Add: > * Log queries where the optimizer row estimates were

2005-04-19 Thread Bruce Momjian
Log Message: --- Add: > * Log queries where the optimizer row estimates were dramatically > different from the number of rows actually found (?) Modified Files: -- pgsql/doc: TODO (r1.1498 -> r1.1499) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc

[COMMITTERS] pgsql: Add: > * All ability to monitor the use of temporary sort files

2005-04-19 Thread Bruce Momjian
Log Message: --- Add: > * All ability to monitor the use of temporary sort files Modified Files: -- pgsql/doc: TODO (r1.1497 -> r1.1498) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1497&r2=1.1498) ---(end o

[COMMITTERS] pgsql: Add: > * All ability to monitor the use of temporary sort files

2005-04-19 Thread Bruce Momjian
Log Message: --- Add: > * All ability to monitor the use of temporary sort files Modified Files: -- pgsql/doc/src/FAQ: TODO.html (r1.4 -> r1.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.4&r2=1.5) ---

[COMMITTERS] pgsql: Create executor and planner-backend support for decoupled heap

2005-04-19 Thread Tom Lane
Log Message: --- Create executor and planner-backend support for decoupled heap and index scans, using in-memory tuple ID bitmaps as the intermediary. The planner frontend (path creation and cost estimation) is not there yet, so none of this code can be executed. I have tested it using so

[COMMITTERS] python - be: Use remove type_dealloc and rely on the inherited

2005-04-19 Thread James William Pye
Log Message: --- Use remove type_dealloc and rely on the inherited obj_dealloc. Move stuff to type_clear. Modified Files: -- be/src: type.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/type.c.diff?r1=1.5&r2=1.6) ---

[COMMITTERS] python - be: Forget about NotPyPgTransaction Remove owner checks as

2005-04-19 Thread James William Pye
Log Message: --- Forget about NotPyPgTransaction Remove owner checks as these should be straight interfaces, rather than attempts to weasle it in to the procedure context. Add ist_count to globals and externs. Other minor touch-ups. Modified Files: -- be/include/pypg:

[COMMITTERS] python - be: Allow Oid_FromPyObject to implicity use a type's Oid Check

2005-04-19 Thread James William Pye
Log Message: --- Allow Oid_FromPyObject to implicity use a type's Oid Check the result of PyNumber_Int and return InvalidOid on error. This should be more stingy about what it will take, but for now it's convenient. Modified Files: -- be/src: conv.c (r1.3 -> r1.4)

[COMMITTERS] python - be: New constants and IST interfaces Add subtransaction

2005-04-19 Thread James William Pye
Log Message: --- New constants and IST interfaces Add subtransaction interfaces with *very* basic support for protecting over-Release/Rollback from FATAL'ing. Postgres.Begin, Postgres.Release, and Postgres.Rollback. Change Get-TransactionId/CommandID/UserId to use Postgres.Object's. Forge

[COMMITTERS] pgsql: Add comment about permissions on pg_ts* tables

2005-04-19 Thread Teodor Sigaev
Log Message: --- Add comment about permissions on pg_ts* tables Modified Files: -- pgsql/contrib/tsearch2/docs: tsearch-V2-intro.html (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/docs/tsearch-V2-intro.html.diff?r1=1.5&r2

[COMMITTERS] pgsql: Add comment about permissions on pg_ts* tables

2005-04-19 Thread Teodor Sigaev
Log Message: --- Add comment about permissions on pg_ts* tables Tags: REL7_4_STABLE Modified Files: -- pgsql/contrib/tsearch2/docs: tsearch-V2-intro.html (r1.2 -> r1.2.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/docs/tsearc

[COMMITTERS] pgsql: Add comment about permissions on pg_ts* tables

2005-04-19 Thread Teodor Sigaev
Log Message: --- Add comment about permissions on pg_ts* tables Tags: REL8_0_STABLE Modified Files: -- pgsql/contrib/tsearch2/docs: tsearch-V2-intro.html (r1.5 -> r1.5.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/docs/tsearc