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

[Дмитрий Шалашов <skaurus@xxxxxxxxx>]

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