Horton

Re: Hot Standby (v9d)

Andrew Dunstan <andrew@dunslane.net>

View thread View on postgr.es
From: Andrew Dunstan <andrew@dunslane.net>
To: Hannu Krosing <hannu@krosing.net>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, jd@commandprompt.com, Simon Riggs <simon@2ndQuadrant.com>, Gregory Stark <stark@enterprisedb.com>, Mark Kirkwood <markir@paradise.net.nz>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2009-02-03T13:40:56Z
Lists: pgsql-hackers 

Hannu Krosing wrote:
> Actually we came up with a solution to this - use filesystem level
> snapshots (like LVM2+XFS or ZFS), and redirect backends with
> long-running queries to use fs snapshot mounted to a different
> mountpoint.
>
> I don't think Simon has yet put full support for it in code, but it is
> clearly _the_ solution for those who want to eat the cake and have it
> too.
>
>   


How does that work if you're using mutiple file systems via tablespaces 
(e.g. indexes in a different TS)?

cheers

andrew