Re: Bad query plans for queries on partitioned table
От | Gregory Stark |
---|---|
Тема | Re: Bad query plans for queries on partitioned table |
Дата | |
Msg-id | 8763ze6kku.fsf@oxford.xeocode.com обсуждение исходный текст |
Ответ на | Re: Bad query plans for queries on partitioned table (Julian Mehnle <julian@mehnle.net>) |
Ответы |
Re: Bad query plans for queries on partitioned table
|
Список | pgsql-performance |
"Julian Mehnle" <julian@mehnle.net> writes: > I actually do have constraints on all the partitions, e.g. for week 34: > > Check constraints [for email_2007_week34]: > "email_2007_week34_ts_check" CHECK (ts >= '2007-08-20 00:00:00'::timestamp without time zone AND ts < '2007-08-27 00:00:00'::timestampwithout time zone) > > Check constraints [for email_2007_week34_extras]: > "email_2007_week34_extras_ts_check" CHECK (ts >= '2007-08-20 00:00:00'::timestamp without time zone AND ts < '2007-08-2700:00:00'::timestamp without time zone) > > Shouldn't this be enough to give the query planner a clue that it only > has to join the "email" and "email_extras" tables' partitions pair-wise, > as opposed to cross-joining them? Ah, well, this falls under "The optimizer is a bit dumb about partitioned tables". It only looks at the constraints to compare against your WHERE clause. It doesn't compare them against the constraints for other tables to see if they're partitioned on the same key and therefore can be joined table-by-table. I want 8.4 to be cleverer in this area but there's a ton of things it has to learn. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!
В списке pgsql-performance по дате отправления: