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

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: David Fetter <david@fetter.org>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Declarative partitioning
Date: Thu, 20 Aug 2015 10:36:11 -0700
Message-ID: <55D6100B.60300@agliodbs.com> (raw)
In-Reply-To: <WM!ba7d9518d4247e60f125e3f655ea714235d94a520d48911df38cf20faa56ee4a2b85cb315e627cdfb80e3b36960d989a!@asav-3.01.com>
References: <55D3093C.5010800@lab.ntt.co.jp>
	<20150818134323.GC18054@fetter.org>
	<55D4309F.8030601@lab.ntt.co.jp>
	<20150819125239.GE11258@fetter.org>
	<55D5A4C0.4040900@lab.ntt.co.jp>
	<20150820131902.GB8691@fetter.org>
	<WM!ba7d9518d4247e60f125e3f655ea714235d94a520d48911df38cf20faa56ee4a2b85cb315e627cdfb80e3b36960d989a!@asav-3.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 08/20/2015 06:19 AM, David Fetter wrote:
> On Thu, Aug 20, 2015 at 06:58:24PM +0900, Amit Langote wrote:
>> Do you mean ATTACH and DETACH, if they require access exclusive lock on
>> the parent, should not be in the first cut? Or am I misreading?
> 
> Sorry I was unclear.
> 
> ATTACH and DETACH should be in the first cut even if they require an
> access exclusive lock.
> 
> Cheers,
> David.

I don't see a way for them to *ever* not require an access exclusive lock.

We could eventually implement:

DETACH PARTITION CONCURRENTLY

... but that's the only way I can see around it.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (161+ messages)  latest in thread

Message-ID: <55D6100B.60300@agliodbs.com>
Permalink:  ../55D6100B.60300@agliodbs.com/
Also on:    postgresql.org/message-id/55D6100B.60300@agliodbs.com

 · 

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: josh@agliodbs.com, david@fetter.org, Langote_Amit_f8@lab.ntt.co.jp
  Subject: Re: Declarative partitioning
  In-Reply-To: <55D6100B.60300@agliodbs.com>

* 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