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