Hello! Le 2014-10-16 à 08:35, Дмитрий Шалашов <skaurus@xxxxxxxxx> a écrit : > 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? Could you share a specific plan with us, as well as your PostgreSQL version? It would make the conversation much easier. Can you also confirm your constraint_exclusion parameter is set to either 'partition' or 'on'? Thanks! François Beausoleil -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
