pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Andrey Klychkov <aaklychkov@mail.ru>
Cc: Victor Yegorov <vyegorov@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Alter index rename concurrently to
Date: Thu, 02 Aug 2018 16:29:36 -0400
Message-ID: <5607.1533241776@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+TgmoZ6vjMjQmzbpQkLBB9iY03SBx+gWHpsgwpyjzQAoZ3nrw@mail.gmail.com>
References: <1531767486.432607658@f357.i.mail.ru>
	<CAGnEboiyFkmGbQFAvc+tViayyPnbJkWTd93kvmhhML+cQQ_OkA@mail.gmail.com>
	<1531828116.497549417@f411.i.mail.ru>
	<6cf6b35f-b730-60fc-bab7-82699dca59ed@2ndquadrant.com>
	<CA+TgmobtmFT5g-0dA=vEFFtogjRAuDHcYPw+qEdou5dZPnF=pg@mail.gmail.com>
	<c3d9a44c-2ca1-6726-ad03-ed9c37cc7c29@2ndquadrant.com>
	<10678.1533072318@sss.pgh.pa.us>
	<4aadd527-9986-36bd-978c-2300a95e7aec@2ndquadrant.com>
	<CA+TgmoZVYSVqNuuw3tzUWcTNaeBj_XvAB8F9+bsesw-NKj=SKA@mail.gmail.com>
	<20180801193616.gi7mfs4kn5kggamf@alap3.anarazel.de>
	<CA+TgmoZ6vjMjQmzbpQkLBB9iY03SBx+gWHpsgwpyjzQAoZ3nrw@mail.gmail.com>

Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Aug 1, 2018 at 3:36 PM, Andres Freund <andres@anarazel.de> wrote:
>> What precisely are you proposing?

> Inserting AcceptInvalidationMessages() in some location that
> guarantees it will be executed at least once per SQL statement.  I
> tentatively propose the beginning of parse_analyze(), but I am open to
> suggestions.

What will that accomplish that the existing call in transaction start
doesn't?  It might make the window for concurrency issues a bit narrower,
but it certainly doesn't close it.

			regards, tom lane




view thread (31+ messages)  latest in thread

Message-ID: <5607.1533241776@sss.pgh.pa.us>
Permalink:  ../5607.1533241776@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5607.1533241776@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, andres@anarazel.de, peter.eisentraut@2ndquadrant.com, aaklychkov@mail.ru, vyegorov@gmail.com
  Subject: Re: Alter index rename concurrently to
  In-Reply-To: <5607.1533241776@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox