Dave Johansen <davejohansen@xxxxxxxxx> writes: > I'm trying to call MAX() on the first value of a multi-column index of a > partitioned table and the planner is choosing to do a sequential scan > instead of an index scan. Is there something I can do to fix this? What PG version are you using? 9.1 or newer should know how to do this with a merge append of several indexscans. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
