Re: Hot Standby (v9d)
От | Simon Riggs |
---|---|
Тема | Re: Hot Standby (v9d) |
Дата | |
Msg-id | 1233671282.4500.146.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: Hot Standby (v9d) (Andrew Dunstan <andrew@dunslane.net>) |
Ответы |
Re: Hot Standby (v9d)
|
Список | pgsql-hackers |
On Tue, 2009-02-03 at 08:40 -0500, Andrew Dunstan wrote: > > 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)? It's a great idea and easy to do, but I can't do everything in one go. The main reasons not to are multiple file system difficulties and lack of a mainstream Linux solution, and more simply lack of time and test resources. So not now, maybe later. -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: