Re: Hot-standby and canceled queries

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Hot-standby and canceled queries
Date: 2013-04-24 15:34:16
Message-ID: 20130424113416.2d6705e8@hydrogen.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 24 Apr 2013 14:01:13 +0100
Simon Riggs <simon(at)2ndQuadrant(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Adarsh Sharma 2013-04-25 00:00:53 Standby and replication terminated due to Server PANIC
Previous Message Simon Riggs 2013-04-24 13:01:13 Re: Hot-standby and canceled queries