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