Hi Benoit,
Are you talking specifically the database?
You can run up 100's of gigs of log files in pg_log if you're not careful (he
says after doing the very same).
Cheers
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 10:01
To:
Dunno about quickly, but I usually do something like this (before slapping
myself in the face for getting into that state):
CREATE TABLE tn_backup AS SELECT DISTINCT * FROM tn;
TRUNCATE TABLE tn;
INSERT INTO tn VALUES SELECT * from tn_backup;
(Where tn is the table name)
May not be the best