[COMMITTERS] pgsql: When truncating a relation in-place (eg during VACUUM), do not

2006-11-19 Thread Tom Lane
Log Message: --- When truncating a relation in-place (eg during VACUUM), do not try to unlink any no-longer-needed segments; just truncate them to zero bytes and leave the files in place for possible future re-use. This avoids problems when the segments are re-used due to relation growth s

[COMMITTERS] pgsql: When truncating a relation in-place (eg during VACUUM), do not

2006-11-19 Thread Tom Lane
Log Message: --- When truncating a relation in-place (eg during VACUUM), do not try to unlink any no-longer-needed segments; just truncate them to zero bytes and leave the files in place for possible future re-use. This avoids problems when the segments are re-used due to relation growth s

[COMMITTERS] pgsql: When truncating a relation in-place (eg during VACUUM), do not

2006-11-19 Thread Tom Lane
Log Message: --- When truncating a relation in-place (eg during VACUUM), do not try to unlink any no-longer-needed segments; just truncate them to zero bytes and leave the files in place for possible future re-use. This avoids problems when the segments are re-used due to relation growth s

[COMMITTERS] pgsql: Repair problems with hash indexes that span multiple segments:

2006-11-19 Thread Tom Lane
Log Message: --- Repair problems with hash indexes that span multiple segments: the hash code's preference for filling pages out-of-order tends to confuse the sanity checks in md.c, as per report from Balazs Nagy in bug #2737. The fix is to ensure that the smgr-level code always has the sa

[COMMITTERS] pgsql: Repair problems with hash indexes that span multiple segments:

2006-11-19 Thread Tom Lane
Log Message: --- Repair problems with hash indexes that span multiple segments: the hash code's preference for filling pages out-of-order tends to confuse the sanity checks in md.c, as per report from Balazs Nagy in bug #2737. The fix is to ensure that the smgr-level code always has the sa

[COMMITTERS] pgsql: Repair problems with hash indexes that span multiple segments:

2006-11-19 Thread Tom Lane
Log Message: --- Repair problems with hash indexes that span multiple segments: the hash code's preference for filling pages out-of-order tends to confuse the sanity checks in md.c, as per report from Balazs Nagy in bug #2737. The fix is to ensure that the smgr-level code always has the sa

[COMMITTERS] pgsql: Repair problems with hash indexes that span multiple segments:

2006-11-19 Thread Tom Lane
Log Message: --- Repair problems with hash indexes that span multiple segments: the hash code's preference for filling pages out-of-order tends to confuse the sanity checks in md.c, as per report from Balazs Nagy in bug #2737. The fix is to ensure that the smgr-level code always has the sa

[COMMITTERS] pgloader - pgloader: removing old pgloader file

2006-11-19 Thread User Dim
Log Message: --- removing old pgloader file Added Files: --- pgloader: Makefile (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgloader/pgloader/Makefile?rev=1.1&content-type=text/x-cvsweb-markup) pgloader.1.sgml (r1.1) (http://cvs.pgfound

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/clob In directory pgfoundry.org:/tmp/cvs-serv73428/clob Log Message: Directory /cvsroot/pgloader/pgloader/examples/clob added to the repository ---(end of broadcast)--- TIP 1: if posting/reading through

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/simple In directory pgfoundry.org:/tmp/cvs-serv73428/simple Log Message: Directory /cvsroot/pgloader/pgloader/examples/simple added to the repository ---(end of broadcast)--- TIP 9: In versions below 8.

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/errors In directory pgfoundry.org:/tmp/cvs-serv73428/errors Log Message: Directory /cvsroot/pgloader/pgloader/examples/errors added to the repository ---(end of broadcast)--- TIP 6: explain analyze is y

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples/cluttered In directory pgfoundry.org:/tmp/cvs-serv73428/cluttered Log Message: Directory /cvsroot/pgloader/pgloader/examples/cluttered added to the repository ---(end of broadcast)--- TIP 6: explain ana

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/debian In directory pgfoundry.org:/tmp/cvs-serv72703/debian Log Message: Directory /cvsroot/pgloader/pgloader/debian added to the repository ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[COMMITTERS] pgloader - pgloader: New Directory

2006-11-19 Thread User Dim
Update of /cvsroot/pgloader/pgloader/examples In directory pgfoundry.org:/tmp/cvs-serv72703/examples Log Message: Directory /cvsroot/pgloader/pgloader/examples added to the repository ---(end of broadcast)--- TIP 9: In versions below 8.0, the plann