Re: Hot Standby query cancellation and Streaming Replication integration - Mailing list pgsql-hackers

From Aidan Van Dyk
Subject Re: Hot Standby query cancellation and Streaming Replication integration
Date
Msg-id 20100227045348.GK7843@oak.highrise.ca
Whole thread Raw
In response to Re: Hot Standby query cancellation and Streaming Replication integration  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Hot Standby query cancellation and Streaming Replication integration
List pgsql-hackers
* Greg Smith <greg@2ndquadrant.com> [100226 23:39]:

> Just not having the actual query running on the master is such a  
> reduction in damage that I think it's delivering the essence of what  
> people are looking for regardless.  That it might be possible in some  
> cases to additionally avoid the overhead that comes along with any  
> long-running query is a nice bonus, and it's great the design allows for  
> that possibility.  But if that's only possible with risk, heavy  
> tweaking, and possibly some hacks, I'm not sure that's making the right  
> trade-offs for everyone.

Would we (ya, the royal we) be willing to say that if you want the
benifit of removing the MVCC overhead of long-running queries you need
to run PITR backup/archive recovery, and if you want SR, you get a
closed-loop master-follows-save-xmin behaviour?

a.

-- 
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Greg Smith
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration