Re: PostgreSQL Replication with read-only access to standby DB - Mailing list pgsql-general

From Vivek Khera
Subject Re: PostgreSQL Replication with read-only access to standby DB
Date
Msg-id 95489EEE-EDE1-46EC-AD62-34BEE878237A@khera.org
Whole thread Raw
In response to Re: PostgreSQL Replication with read-only access to standby DB  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: mark
Date:
Subject: Re: simple update queries take a long time - postgres 8.3.1
Next
From: Raymond O'Donnell
Date:
Subject: Re: simple update queries take a long time - postgres 8.3.1