Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 31 Mar 2008 15:45:49 -0400
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 doesnot 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.
- References:
- PostgreSQL Replication with read-only access to standby DB
- From: Keaton Adams
- Re: PostgreSQL Replication with read-only access to standby DB
- From: Jeff Davis
- PostgreSQL Replication with read-only access to standby DB
- Prev by Date: Re: simple update queries take a long time - postgres 8.3.1
- Next by Date: Re: simple update queries take a long time - postgres 8.3.1
- Previous by thread: Re: PostgreSQL Replication with read-only access to standby DB
- Next by thread: Re: PostgreSQL Replication with read-only access to standby DB
- Indexes: