On 22 March 2010 14:19, Tom Lane <t...@sss.pgh.pa.us> wrote: > Thom Brown <thombr...@gmail.com> writes: > > I noticed there's 66 files in my pg_xlog directory. I changed my > > checkpoint_segments from 32 to 3 as I noticed it was too high, restarted > > PosgreSQL, but there are still 66 files in that directory and they're > taking > > up about 1.1G. > > > How can I get this list of files down? > > Force a checkpoint, if one hasn't happened already. > > regards, tom lane >
Hi Tom, Yeah, I've run a CHECKPOINT too, but no joy. Still the same number of files. Thom