Rafael Martinez writes:
> But this doesn't explain the WAL files not been created/recycled
> time-ordered. I wonder if this happened because the partition got full
> while the WALs were created/recycled?
When a checkpoint finishes, it scans the pg_xlog directory to find WAL
files that are no long
On Wed, 2011-04-13 at 06:28 -0700, Adrian Klaver wrote:
> On Wednesday, April 13, 2011 6:09:25 am Rafael Martinez wrote:
>
> Might want to take a look at:
>
[..]
> sequence). If, due to a short-term peak of log output rate, there are
> more than 3 * checkpoint_segments + 1 segment files, th
On Wednesday, April 13, 2011 6:09:25 am Rafael Martinez wrote:
> Hello
>
> Yesterday we had a weird problem with the pg_xlog partition in one of
> our servers:
>
> - The amount of WAL files was much higher than (2*checkpoint_segments)+1
> (over 360 WAL files)
>
Might want to take a look at:
htt
