Re: Hot Standby (v9d) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Hot Standby (v9d)
Date
Msg-id 49884968.4050900@dunslane.net
Whole thread Raw
In response to Re: Hot Standby (v9d)  (Hannu Krosing <hannu@krosing.net>)
Responses Re: Hot Standby (v9d)
Re: Hot Standby (v9d)
List 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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Hot Standby (v9d)
Next
From: Gregory Stark
Date:
Subject: Re: Hot Standby (v9d)