Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF
Дата
Msg-id 3980888.1679002050@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> On Thu, Mar 16, 2023 at 04:52:07PM -0400, Tom Lane wrote:
>       It is possible to use <link linkend="sql-altertable"><command>ALTER
>       TABLE ATTACH/DETACH PARTITION</command></link> to perform these
>       operations with a weaker lock, thus reducing interference with
>       concurrent operations on the partitioned table.

> Note that in order for DETACH+DROP to use a lower lock level, it has to be
> DETACH CONCURRENTLY.  ATTACH is implicitly uses a lower lock level, but for
> DETACH it's only on request.

Right, but that's the sort of detail you should read on that command's man
page, we don't need to duplicate it in N other places.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Add LZ4 compression in pg_dump
Следующее
От: Andres Freund
Дата:
Сообщение: Re: More weird compiler warnings