Re: synchronized snapshots

Dnia 2010-01-09 o godz. 20:37 Markus Wanner <markus@bluegap.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