Partitioned tables and SELECT ... ORDER BY ... LIMIT

Поиск
Список
Период
Сортировка
От Дмитрий Шалашов
Тема Partitioned tables and SELECT ... ORDER BY ... LIMIT
Дата
Msg-id CAKPeCUFwqc9OTYjtGAam=tu3E1e2SaNp69YnovUPP5f3c6EAnw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT  (François Beausoleil <francois@teksol.info>)
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi,

lets imagine that we have some table, partitioned by timestamp field, and we query it with SELECT with ordering by that field (DESC for example), with some modest limit.
Lets further say that required amount of rows is found in the first table that query encounters (say, latest one).
I am just wondering, why nevertheless PostgreSQL does read couple of buffers from each of the older tables?

Best regards,
Dmitriy Shalashov

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Partitions and work_mem?
Следующее
От: François Beausoleil
Дата:
Сообщение: Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT