Re: Hot-standby and canceled queries - Mailing list pgsql-admin

From David F. Skoll
Subject Re: Hot-standby and canceled queries
Date
Msg-id 20130424113416.2d6705e8@hydrogen.roaringpenguin.com
Whole thread Raw
In response to Re: Hot-standby and canceled queries  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
On Wed, 24 Apr 2013 14:01:13 +0100
Simon Riggs <simon@2ndQuadrant.com> wrote:

[How to ensure query on hot-standby is not canceled by a
 vacuum cleanup on the master.]

>> do I need to use UPDATE or INSERT to ensure that a vacuum cleanup
>> isn't applied until the transaction is finished?

> SELECT is sufficient

Great!  Thanks for your reply.

Regards,

David.


pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot-standby and canceled queries
Next
From: Adarsh Sharma
Date:
Subject: Standby and replication terminated due to Server PANIC