pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
WAL logs eating my diskspace!! 2+ messages / 2 participants [nested] [flat]
* WAL logs eating my diskspace!! @ 2001-05-11 19:40 webb sprague <wsprague@o1.com> 0 siblings, 1 reply; 2+ messages in thread From: webb sprague @ 2001-05-11 19:40 UTC (permalink / raw) To: pgsql-general@postgresql.org Is there a way to flush them more often? 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. Thanks ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: WAL logs eating my diskspace!! @ 2001-05-11 23:30 Tom Lane <tgl@sss.pgh.pa.us> parent: webb sprague <wsprague@o1.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2001-05-11 23:30 UTC (permalink / raw) To: webb sprague <wsprague@o1.com>; +Cc: pgsql-general@postgresql.org webb sprague <wsprague@o1.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-11 23:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-05-11 19:40 WAL logs eating my diskspace!! webb sprague <wsprague@o1.com> 2001-05-11 23:30 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox