Re: Question on overall design

Поиск

Список

Период

Сортировка

От	Dominique Devienne
Тема	Re: Question on overall design
Дата	11 декабря 2023 г. 12:41:39
Msg-id	CAFCRh-_T34JN-1gfKfNOmLb=C-+wrSHY8qwG2bc+Ord=vbQzew@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Question on overall design (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы	Re: Question on overall design
Список	pgsql-general

On Sun, Dec 10, 2023 at 5:56 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

* We departitioned because SELECT statements were slow. All partitions were scanned, even when the partition key was specified in the WHERE clause.

Surely that's no the case on newer PostgreSQL, is it? Otherwise what's the point of partitioning?

Also, I remember reading something about recent improvements with a large number of partitions, no?

As someone who's interested on partitioning, I'd appreciate details. Thanks, --DD

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

От: veem v
Дата: 11 декабря 2023 г., 11:59:21
Сообщение: Re: Question on overall design

От: Chris Travers
Дата: 11 декабря 2023 г., 13:00:17
Сообщение: Re: running \copy through perl dbi ?