Re: huge memory of Postgresql backend process

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: huge memory of Postgresql backend process
Дата
Msg-id CAApHDvoSOQpgxXnCDH1wZ9xmR+XmQprMBAJ09tVYrA2JezqhmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: huge memory of Postgresql backend process  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: huge memory of Postgresql backend process  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
On Fri, 9 Sept 2022 at 01:48, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Moreover, HASH partitioning is effectively incapable of being
> pruned, so that every query is going to touch every partition.
> (IMO, hash partitioning is basically never a good idea.)

I think that might have only briefly been true during the v11 cycle,
but by the time the release came we had hash partition and partition
pruning.

David

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: huge memory of Postgresql backend process
Следующее
От: Japin Li
Дата:
Сообщение: Re: BUG #17610: Use of multiple composite types incompatible with record-typed function parameter