Partitioned tables and SELECT ... ORDER BY ... LIMIT - Mailing list pgsql-performance

From Дмитрий Шалашов
Subject Partitioned tables and SELECT ... ORDER BY ... LIMIT
Date
Msg-id CAKPeCUFwqc9OTYjtGAam=tu3E1e2SaNp69YnovUPP5f3c6EAnw@mail.gmail.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Partitions and work_mem?
Next
From: François Beausoleil
Date:
Subject: Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT