[COMMITTERS] pgsnmpd - pgsnmpd: Make this work in more than just bash

2007-09-08 Thread User Eggyknap
Log Message:
---
Make this work in more than just bash

Modified Files:
--
pgsnmpd/pgsql_mib_pieces:
reprocess.sh (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/reprocess.sh.diff?r1=1.2&r2=1.3)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[COMMITTERS] pgsnmpd - pgsnmpd: Add pg_namespace, pg_opclass, and pg_operator (and

2007-09-08 Thread User Eggyknap
Log Message:
---
Add pg_namespace, pg_opclass, and pg_operator (and reprocess a bunch of MIBs so 
it thinks it's gotta check in all the other MIBs I've already completed)

Added Files:
---
pgsnmpd/pgsql_mib_pieces:
pg_namespace.mib (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_namespace.mib?rev=1.1&content-type=text/x-cvsweb-markup)
pg_namespace.tbldef (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_namespace.tbldef?rev=1.1&content-type=text/x-cvsweb-markup)
pg_opclass.mib (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_opclass.mib?rev=1.1&content-type=text/x-cvsweb-markup)
pg_opclass.tbldef (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_opclass.tbldef?rev=1.1&content-type=text/x-cvsweb-markup)
pg_operator.mib (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_operator.mib?rev=1.1&content-type=text/x-cvsweb-markup)
pg_operator.tbldef (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_operator.tbldef?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Replace the former method of determining snapshot xmax --- to

2007-09-08 Thread Tom Lane
Log Message:
---
Replace the former method of determining snapshot xmax --- to wit, calling
ReadNewTransactionId from GetSnapshotData --- with a "latestCompletedXid"
variable that is updated during transaction commit or abort.  Since
latestCompletedXid is written only in places that had to lock ProcArrayLock
exclusively anyway, and is read only in places that had to lock ProcArrayLock
shared anyway, it adds no new locking requirements to the system despite being
cluster-wide.  Moreover, removing ReadNewTransactionId from snapshot
acquisition eliminates the need to take both XidGenLock and ProcArrayLock at
the same time.  Since XidGenLock is sometimes held across I/O this can be a
significant win.  Some preliminary benchmarking suggested that this patch has
no effect on average throughput but can significantly improve the worst-case
transaction times seen in pgbench.  Concept by Florian Pflug, implementation
by Tom Lane.

Modified Files:
--
pgsql/src/backend/access/transam:
README (r1.8 -> r1.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/README?r1=1.8&r2=1.9)
transam.c (r1.70 -> r1.71)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/transam.c?r1=1.70&r2=1.71)
twophase.c (r1.34 -> r1.35)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase.c?r1=1.34&r2=1.35)
varsup.c (r1.78 -> r1.79)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/varsup.c?r1=1.78&r2=1.79)
xact.c (r1.249 -> r1.250)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c?r1=1.249&r2=1.250)
xlog.c (r1.280 -> r1.281)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.280&r2=1.281)
pgsql/src/backend/catalog:
heap.c (r1.322 -> r1.323)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c?r1=1.322&r2=1.323)
pgsql/src/backend/commands:
vacuum.c (r1.356 -> r1.357)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c?r1=1.356&r2=1.357)
pgsql/src/backend/storage/ipc:
procarray.c (r1.32 -> r1.33)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c?r1=1.32&r2=1.33)
pgsql/src/backend/storage/lmgr:
proc.c (r1.193 -> r1.194)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/proc.c?r1=1.193&r2=1.194)
pgsql/src/backend/utils/time:
tqual.c (r1.104 -> r1.105)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/time/tqual.c?r1=1.104&r2=1.105)
pgsql/src/include/access:
transam.h (r1.61 -> r1.62)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/transam.h?r1=1.61&r2=1.62)
xact.h (r1.89 -> r1.90)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/xact.h?r1=1.89&r2=1.90)
pgsql/src/include/storage:
procarray.h (r1.16 -> r1.17)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/procarray.h?r1=1.16&r2=1.17)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org