Re: WIP partial replication patch

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
Subject: Re: WIP partial replication patch
Date: 2010-08-14 06:40:24
Message-ID: 4C663A58.8060502@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund írta:
> On Fri, Aug 13, 2010 at 09:36:00PM +0200, Boszormenyi Zoltan wrote:
>
>> Tom Lane írta:
>>
>>> Boszormenyi Zoltan <zb(at)cybertec(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2010-08-14 07:05:30 Re: Per-column collation, proof of concept
Previous Message Hitoshi Harada 2010-08-14 04:50:58 Re: BUG #5608: array_agg() consumes too much memory