Thanks for your help, its working now :-). Yours: Dario Brignardello Tom Lane wrote: > Dario Brignardello <[EMAIL PROTECTED]> writes: > > checkpoint_segments = 1 > > checkpoint_timeout = 30 > > Reducing checkpoint_segments and checkpoint_timeout is actually > seriously counterproductive, if your problem is amount of disk space > chewed up by WAL logs during a long transaction (such as bulk load of > a big table). The WAL log cannot be truncated until the xact commits, > so the checkpoints that happen meanwhile just cause log bloat. Lots > of it, because each checkpoint causes fresh copying of modified pages > into the WAL log. > > Try increasing those numbers, not decreasing them. Maybe 10/600 or so? > > Also, if you are short on disk space for WAL, increasing wal_files isn't > such a great idea either. > > regards, tom lane
S/MIME Cryptographic Signature
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
