On Fri, Nov 30, 2012 at 10:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Claudio Freire <klaussfreire@gmail.com> writes:
>> Without hot standby feedback, reporting queries are impossible. I've
>> experienced it. Cancellations make it impossible to finish any
>> decently complex reporting query.
>
> The original expectation was that slave-side cancels would be
> infrequent. Maybe there's some fixing/tuning to be done there.
It depends completely on the query pattern on the master. Saying that
cancellations makes it "impossible to finish any decently complex
reporting query" is completely incorrect - it depends on the queries
on the *master*, not on the complexity of the query on the slave. I
know a lot of scenarios where query cancels pretty much never happen
at all.
--Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/