Re: [PERFORM] indexes in partitioned tables - again

2010-04-07 Thread Robert Haas
On Tue, Apr 6, 2010 at 5:37 PM, Samuel Gendler wrote: > In part, I'm surprised that the index scan takes as long as it does, > since I'd think an index would be able to return the set of keys > relatively quickly.  But that's a secondary issue. We don't actually have a facility built into the ind

[PERFORM] indexes in partitioned tables - again

2010-04-06 Thread Samuel Gendler
I know this problem crops up all the time and I have read what I could find, but I'm still not finding an answer to my problem. This is all postgres 8.3. Yes, I've enabled constraint_exclusion. Yes, there are indexes on the partitions, not just on the parent. I've got a table with 1 month partit