Re: [HACKERS] Relpartbound, toasting and pg_class

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Relpartbound, toasting and pg_class
Дата
Msg-id 11481.1497303813@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Relpartbound, toasting and pg_class  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] Relpartbound, toasting and pg_class  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2017-06-12 17:10:28 -0400, Peter Eisentraut wrote:
>> Cases where relacl became too large have been known to exist.  I'm not
>> sure whether relpartbound can really be that large to change the
>> scenario significantly.

> Because it's further increasing the size by something unbounded in size,
> which'll not uncommonly be large? It makes a fair amount of sense to
> partition by multiple columns at once (using the expression syntax).

How about gathering some actual evidence on the point --- ie, how big
a partition expression do you need to make it fall over?
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] ICU support on Windows