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

Re: synchronized snapshots

From: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>
To: Markus Wanner <markus(at)bluegap(dot)ch>
Cc: Joachim Wieland <joe(at)mcknight(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: synchronized snapshots
Date: 2010-01-09 20:44:38
Message-ID: F5D22F22-CF0B-4709-85FE-83325BF2C02D@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers

Dnia 2010-01-09 o godz. 20:37 Markus Wanner <markus(at)bluegap(dot)ch> napisał 
(a):

> Hi
>
> Joachim Wieland wrote:
>> Since nobody objected to the idea in general, I have implemented it.

How cool it would be if we could synchronize snapshots between the  
master and the (sr) standby?

The connection poolers could use that to send read-only queries to the  
standby, and when the first dml/ddl statement in a transaction comes  
up, they could switch to the master.

If it is hard to tell from the statement if it writes anything, the  
pooler could catch the error, and retry on the master

Regards
Marcin Mańk 

In response to

pgsql-hackers by date

Next:From: Dean RasheedDate: 2010-01-09 20:53:54
Subject: Re: Re: CVS HEAD: Error accessing system column from plpgsql trigger function
Previous:From: Tom LaneDate: 2010-01-09 20:28:11
Subject: Re: Re: CVS HEAD: Error accessing system column from plpgsql trigger function

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