Horton

Re: Latest version of Hot Standby patch

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: Simon Riggs <simon@2ndQuadrant.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2009-01-14T08:12:17Z
Lists: pgsql-hackers 
On Wed, 2009-01-14 at 08:27 +0200, Heikki Linnakangas wrote:
> Thanks for picking this up, despite my report was so vague.
> 
> Simon Riggs wrote:
> > Best way seems to be to do (almost) the same thing as ExtendSubtrans()
> > during recovery, so we zero out pages at the point that recovering
> > transactions get written to pg_subtrans.
> 
> Yep.
> 
> Do we have the same bug with ExtendCLOG?

No, the clog issues WAL records for that. 8 times less than subtrans
would if we allowed it to, so its not as bad performance wise either.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support