Skip site navigation (1) Skip section navigation (2)

Re: Disabled features on Hot Standby

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Disabled features on Hot Standby
Date: 2012-01-13 15:36:32
Message-ID: CA+TgmoaZo8OJjgrCKBucudzSRZxWxhMB6c8N6rrzP2rz7Zbu_w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Jan 13, 2012 at 10:31 AM, Jim Nasby <jim(at)nasby(dot)net> wrote:
> Perhaps it would be possible to keep older copies of pages around when there are older transactions running on the standby?

I've thought about that... it's basically a rollback segment, which
for that matter might be judged superior to what we do on the master
(i.e. VACUUM).  Needless to say, that would be just a teensy bit more
work than we're likely to have time for in 9.2.  But maybe for 10.2...

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-hackers by date

Next:From: Peter GeogheganDate: 2012-01-13 15:41:45
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans
Previous:From: Robert HaasDate: 2012-01-13 15:31:42
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group