[COMMITTERS] pgsql: Reduce spurious Hot Standby conflicts from never-visible records

2010-12-09 Thread Simon Riggs
Reduce spurious Hot Standby conflicts from never-visible records. Hot Standby conflicts only with tuples that were visible at some point. So ignore tuples from aborted transactions or for tuples updated/deleted during the inserting transaction when generating the conflict transaction ids. Followin

[COMMITTERS] pgsql: Self review of previous patch. Fix assumption that xmax >= xmin.

2010-12-09 Thread Simon Riggs
Self review of previous patch. Fix assumption that xmax >= xmin. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=9975c683b102d06ed5d5ab799eaba0d00a9ff38c Modified Files -- src/backend/access/heap/heapam.c |6 ++ 1 files cha

[COMMITTERS] psqlodbc - psqlodbc: Change to read and skip the rest of result data

2010-12-09 Thread User Hinoue
Log Message: --- Change to read and skip the rest of result data when out of memory occurs while reading tuples so that we can continue to use the connection. Modified Files: -- psqlodbc: columninfo.c (r1.33 -> r1.34) (http://cvs.pgfoundry.org/cgi-bin/cvsw

[COMMITTERS] pgsql: Eliminate O(N^2) behavior in parallel restore with many blobs.

2010-12-09 Thread Tom Lane
Eliminate O(N^2) behavior in parallel restore with many blobs. With hundreds of thousands of TOC entries, the repeated searches in reduce_dependencies() become the dominant cost. Get rid of that searching by constructing reverse-dependency lists, which we can do in O(N) time during the fix_depend

[COMMITTERS] pgsql: Eliminate O(N^2) behavior in parallel restore with many blobs.

2010-12-09 Thread Tom Lane
Eliminate O(N^2) behavior in parallel restore with many blobs. With hundreds of thousands of TOC entries, the repeated searches in reduce_dependencies() become the dominant cost. Get rid of that searching by constructing reverse-dependency lists, which we can do in O(N) time during the fix_depend

[COMMITTERS] pgsql: Reduce spurious Hot Standby conflicts from never-visible records

2010-12-09 Thread Simon Riggs
Reduce spurious Hot Standby conflicts from never-visible records. Hot Standby conflicts only with tuples that were visible at some point. So ignore tuples from aborted transactions or for tuples updated/deleted during the inserting transaction when generating the conflict transaction ids. Followin