Re: Hot Standby query cancellation and Streaming Replication integration
Richard Huxton <dev@archonet.com>
From: Richard Huxton <dev@archonet.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-02-26T14:24:30Z
Lists: 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