Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UV1iQ-0007im-5t for pgsql-admin@arkaria.postgresql.org; Wed, 24 Apr 2013 15:34:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UV1iP-0005xs-HO for pgsql-admin@arkaria.postgresql.org; Wed, 24 Apr 2013 15:34:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UV1iO-0005xn-OG for pgsql-admin@postgresql.org; Wed, 24 Apr 2013 15:34:36 +0000 Received: from www.ipv6.roaringpenguin.com ([2607:f748:1200:fb:70:38:112:54] helo=colo3.roaringpenguin.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UV1i8-0002Ul-LZ for pgsql-admin@postgresql.org; Wed, 24 Apr 2013 15:34:36 +0000 Received: from vanadium.roaringpenguin.com ([192.168.10.23]) by colo3.roaringpenguin.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id r3OFYHda025362 for ; Wed, 24 Apr 2013 11:34:17 -0400 Received: from hydrogen.roaringpenguin.com (dfs@hydrogen.roaringpenguin.com [192.168.10.1]) by vanadium.roaringpenguin.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id r3OFYGoM001937 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NOT) for ; Wed, 24 Apr 2013 11:34:16 -0400 Date: Wed, 24 Apr 2013 11:34:16 -0400 From: "David F. Skoll" To: pgsql-admin Subject: Re: Hot-standby and canceled queries Message-ID: <20130424113416.2d6705e8@hydrogen.roaringpenguin.com> In-Reply-To: References: <20130424074238.2aa7f764@shishi.roaringpenguin.com> Organization: Roaring Penguin Software Inc. X-Mailer: Claws Mail 3.7.6 (GTK+ 2.20.1; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=roaringpenguin.com; h=date :from:to:subject:message-id:in-reply-to:references:mime-version :content-type:content-transfer-encoding; s=main; bh=7PdMbgrdpD73 60Akqjkgfr8/we0=; b=GqxVCUjwHNg1iX+HOLwE+CXduOKSKXAzMP7nKbe1JKjL RyDF00VBESFQY8WqGgdFAiOD79T6e0a3LHwobPUQ1je3Q2viqAMei8pZUN38KxWa tA7I5EEjZ3V2cHkdKXPP2CnG4mWoPKer7frYyWi5x4bnu1wMwa1TPZ7aY3goQXFk KlTh0a8Et4EQ/uvaBKfJSmECBxaLFaSQoGcwnDCvQ6+0TYV7IQraTu+ctbWOp9+v TotnulhXjDiOtzxanlfHO/K7DEeFkNKkBgDojYz6toeFzF5fy/g2JjUGTnr6EEJy fD2V6K6bGvCrxng9ixC+RLOIzMXzOYSZ/pGjdA6kag== X-Scanned-By: CanIt (www . roaringpenguin . com) X-Scanned-By: MIMEDefang 2.73 on 192.168.10.23 X-Spam-Score: undef - relay 192.168.10.23 marked with skip_spam_scan X-CanIt-Geo: No geolocation information available for 192.168.10.23 X-CanItPRO-Stream: outgoing (inherits from default) X-CanIt-Archive-Cluster: SQVyZJxqklY5buiWXYCN4T/BjiM X-CanIt-Archived-As: base/20130424 / 01JrPyhpH X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, 24 Apr 2013 14:01:13 +0100 Simon Riggs 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin