Re: WIP partial replication patch - Mailing list pgsql-hackers

From Boszormenyi Zoltan
Subject Re: WIP partial replication patch
Date
Msg-id 4C663A58.8060502@cybertec.at
Whole thread Raw
In response to Re: WIP partial replication patch  (Andres Freund <andres@anarazel.de>)
Responses Re: WIP partial replication patch
List pgsql-hackers
Andres Freund írta:
> On Fri, Aug 13, 2010 at 09:36:00PM +0200, Boszormenyi Zoltan wrote:
>   
>> Tom Lane írta:
>>     
>>> Boszormenyi Zoltan <zb@cybertec.at> writes:
>>>
>>>       
>>>> attached is a WIP patch that will eventually implement
>>>> partial replication, with the following syntax:
>>>>         
>>> This fundamentally cannot work, as it relies on system catalogs to be
>>> valid during recovery.
>>>       
>> Just like Hot Standby, no? What is the difference here?
>> Sorry for being ignorant.
>>     
> In HS you can only connect after youve found a restartpoint - only
> after that you know that you have reached a consistent point for the
> system.
>   

And in this patch, the startup process only tries to connect
after signalling the postmaster that a consistent state is reached.
And the connection has a reasonable timeout built in.

> I think this is fixable by keeping more wal on the standby's but I
> need to think more about it.
>
> Andres
>
>   

Best regards,
Zoltán Böszörményi



pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: [BUGS] BUG #5608: array_agg() consumes too much memory
Next
From: Jaime Casanova
Date:
Subject: Re: Per-column collation, proof of concept