Re: using index or check in ALTER TABLE SET NOT NULL

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: using index or check in ALTER TABLE SET NOT NULL
Дата
Msg-id CAKJS1f-Y2CAV7y_Vay_bmE=oyZPgtm2qXRinozYOJ0SeopjYtw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: using index or check in ALTER TABLE SET NOT NULL  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: using index or check in ALTER TABLE SET NOT NULL  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
On Thu, 2 May 2019 at 14:22, David Rowley <david.rowley@2ndquadrant.com> wrote:
>
> On Thu, 2 May 2019 at 13:08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >
> > Not a blocker perhaps, but it's better if we can get new behavior to
> > be more or less right the first time.
>
> It's not really new behaviour though. The code in question is for
> ATTACH PARTITION and was added in c31e9d4bafd (back in 2017).
> bbb96c3704c is the commit for using constraints to speed up SET NOT
> NULL. The mention of using the constraint for proof was made DEBUG1 in
> the initial commit.  What we need to decide is if we want to make
> ATTACH PARTITION's INFO message a DEBUG1 in pg12 or not.

FWIW, I'm in favour of changing ATTACH PARTITION's INFO messages to
DEBUG1 for PG12 to align it to what bbb96c3704c did.

Anyone else?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Paul Jungwirth
Дата:
Сообщение: range_agg
Следующее
От: Tomas Vondra
Дата:
Сообщение: accounting for memory used for BufFile during hash joins