Search Postgresql Archives

Re: Decreasing WAL size effects

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Kyle Cordes wrote:
Greg Smith wrote:

there's no chance it can accidentally look like a valid segment.  But when an existing segment is recycled, it gets a new header and that's it--the rest of the 16MB is still left behind from whatever was in that segment before.  That means that even if you only write, say, 1MB of new

[...]

What clearxlogtail does is look inside the WAL segment, and it clears the "tail" behind the portion of that is really used.  So our example file would end up with just the 1MB of useful data, followed by 15MB of


It sure would be nice if there was a way for PG itself to zero the unused portion of logs as they are completed, perhaps this will make it in as part of the ideas discussed on this list a while back to make a more "out of the box" log-ship mechanism?
I agree totally.  I looked at the code for clearxlogtail and it seems short and not very complex.  Hopefully something like this will at least be a trivial to set up option in 8.4.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux