Ashley Moran <[EMAIL PROTECTED]> writes: > BEGIN WORK; > DELETE FROM X; COPY X ...; REINDEX TABLE X; > DELETE FROM Y; COPY Y ...; REINDEX TABLE Y; > DELETE FROM Z; COPY Z ...; REINDEX TABLE Z; > COMMIT;
Why don't you use TRUNCATE? Why do you think you need REINDEX at all? If you do need it, you'd be best off to drop the indexes, truncate, copy, re-create the indexes. See http://www.postgresql.org/docs/8.1/static/populate.html#POPULATE-RM-INDEXES regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
