Re: Hot Standby query cancellation and Streaming Replication integration - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: Hot Standby query cancellation and Streaming Replication integration
Date
Msg-id 4B87D99E.6030608@archonet.com
Whole thread Raw
In response to Re: Hot Standby query cancellation and Streaming Replication integration  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On 26/02/10 14:10, Heikki Linnakangas wrote:
>
> Ideally the standby would stash away the old pages or tuples somewhere
> so that it can still access them even after replaying the WAL records
> that remove them from the main storage. I realize that's not going to
> happen any time soon because it's hard to do, but that would really be
> the most robust fix possible.

Something like snapshotting a filesystem, so updates continue while 
you're still looking at a static version.

--   Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Heikki Linnakangas
Date:
Subject: Re: Assertion failure in walreceiver