Thom Brown writes:
> I've just forced a new WAL file by writing lots of stuff to a table, then
> deleting it. It appears to be recyling the filenames now. The latest files
> end in DD and DE, and the earliest is DF. Presumably these will slowly get
> eaten up until it's just down to the 3 files
On 22 March 2010 16:06, Greg Smith wrote:
> Thom Brown wrote:
>
>> 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 ab
Thom Brown wrote:
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?
A ch
On 22 March 2010 14:29, Tom Lane wrote:
> Thom Brown writes:
> > On 22 March 2010 14:19, Tom Lane wrote:
> >> Force a checkpoint, if one hasn't happened already.
>
> > Yeah, I've run a CHECKPOINT too, but no joy. Still the same number of
> > files.
>
> Hm, it works for me. What PG version is
Thom Brown writes:
> On 22 March 2010 14:19, Tom Lane wrote:
>> Force a checkpoint, if one hasn't happened already.
> Yeah, I've run a CHECKPOINT too, but no joy. Still the same number of
> files.
Hm, it works for me. What PG version is this exactly? Are you sure
the active value of checkpoi
On 22 March 2010 14:19, Tom Lane wrote:
> Thom Brown 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
> > u
Thom Brown 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
Hi,
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?
Thanks
Thom