Re: PostgreSQL Replication with read-only access to standby DB

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Replication with read-only access to standby DB
Date: 2008-03-31 19:45:49
Message-ID: 95489EEE-EDE1-46EC-AD62-34BEE878237A@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Mar 25, 2008, at 4:28 PM, Jeff Davis wrote:
> This obviously does not work in real time, but it may be useful. It
> does
> not require a lot of additional space to do this because of the ZFS
> copy-on-write implementation.

But what benefit does it give you if you're pounding on the same set
of physical disks? You might as well run it on the original since
you're limit is the disk I/O.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-03-31 19:48:06 Re: simple update queries take a long time - postgres 8.3.1
Previous Message Rainer Bauer 2008-03-31 19:41:11 Re: [pgsql-general] Daily digest v1.8030 (22 messages)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-31 19:52:46 Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong
Previous Message Tom Lane 2008-03-31 19:43:30 SPI support needed for EXECUTE USING