On 22 March 2010 14:19, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Thom Brown <thombrown(at)gmail(dot)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