Joshua D. Drake wrote: > Tom Lane wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> We have a problem with CE that I want to verify is either expected > >> behavior, a bug or something else :). > > > > Uh, what's your problem exactly? The example only seems to demonstrate > > that if you don't ask for a sort, you don't get one. > > Sorry. The problem is, if I ask for an ORDER BY it scans all partitions > versus only scanning the partition that has the data in it.
Huh, but that's not what the EXPLAIN ANALYZE you posted says ... -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster