Hello! Le 2014-10-16 à 08:35, Дмитрий Шалашов <skau...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
