| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | webb sprague <wsprague(at)o1(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL logs eating my diskspace!! |
| Date: | 2001-05-11 23:30:05 |
| Message-ID: | 7776.989623805@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
webb sprague <wsprague(at)o1(dot)com> writes:
> Is there a way to flush them more often?
Reduce the time interval between WAL checkpoints. (But don't overdo it.)
Perhaps every three or so minutes, rather than five?
> Otherwise, they can fill up the
> disk space and crash the postmaster. I am doing bulk copies, but the logs
> hang around for up to 20 minutes after the copy is finished.
Another possibility is to issue a manual CHECKPOINT command as soon as
you've finished a bulk copy.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Walter Chong | 2001-05-12 03:03:09 | What's the best front end/client under MS Windows? |
| Previous Message | Kurt Miller | 2001-05-11 23:04:50 | 7.0.2 backend churning out messages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | datactrl | 2001-05-12 00:23:39 | Re: execute client application from PL/pgSql |
| Previous Message | Marc Lamothe | 2001-05-11 20:33:08 | Problem using IP functions |