Simon Riggs wrote:
On Fri, 2006-07-14 at 12:09 -0400, Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
I've now thought about how to fix that without doing that rather crude 
rsync-pg_xlog-hack.
I've read through the code, and learned that wal-segments are expected to have 
a specific size -
thus rotating them "early" is not that easy.
Simon was working on a patch for this at the code sprint; I think it's
submitted to -patches already.


Slightly different patch. I'm working on this one still.
Cool - what are the chances of this being included in 8.2?

Explicitly filling the segment as you
propose would be really bad for performance.

Yes, current approach I am taking is better than that.
Well, my proposal wasn't really a long-term solution - I was thinking about I 
quick fix
that I could implement for 8.1, basically to let my warm-standby-setup feel 
less like
as "house of cards" as someone put it ;-)
I didn't care too much about the performance hit - I don't expect the database 
I indent
to use it for to have much load, otherwise the wal segments are rotated quite 
often anyway.
But I agree that for a general solution, my approach is not really ideal ;-)

Since we just ported the application in question to 8.1, I'm not sure that we 
will switch
to 8.2 when it is released - so I'm still interested in finding a solution for 
8.1

Do you think I could backport your patch to 8.1 - or does it depend on some 
other new features
of 8.2?

greetings, Florian Pflug

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to