On 22 March 2010 14:19, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Force a checkpoint, if one hasn't happened already.Thom Brown <thombrown@xxxxxxxxx> 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?
regards, tom lane
Hi Tom,
Yeah, I've run a CHECKPOINT too, but no joy. Still the same number of files.
Thom