On Thu, May 19, 2011 at 3:24 PM, Noah Misch <n...@leadboat.com> wrote:
> On Thu, May 19, 2011 at 11:42:03AM -0400, Robert Haas wrote:
>> On Thu, May 19, 2011 at 11:13 AM, Noah Misch <n...@leadboat.com> wrote:
>> > It would solve the problem, but it would mean resetting unlogged relations 
>> > on
>> > the standby at every shutdown checkpoint. ?That's probably not a 
>> > performance
>> > problem, but it is a hack.
>> I haven't thought about this too deeply, but I'm not sure I agree
>> that's a hack.  Why do you think it is?
> It would make the standby reset unlogged relations on both regular shutdowns 
> and
> crashes, while the master only does so on crashes.  This creates no functional
> hazard since unlogged relation contents are never accessible during hot 
> standby.
> It seems like a hack to rely on that fact at any distance, but perhaps a 
> comment
> is enough to assuage that.

I think I'd be more comfortable with that route if it seems like it'll
work.  Whacking around the recovery code always makes me a little
nervous about bugs, since it's easy to fail to notice the problem
until something Bad happens.

Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to