Re: [PERFORM] Query with limit goes from few ms to hours

2012-10-14 Thread Tom Lane
henk de wit writes: > For some reason the mailinglist software seems to block the email as soon as > the planner details are in it, so I pasted those on pastebin.com: > http://pastebin.com/T5JTwh5T You need a less horrid estimate for the join size. Possibly an ANALYZE on the parent table (stre

Re: [PERFORM] Index over all partitions (aka global index)?

2012-10-14 Thread Stefan Keller
Yes a physical index would be one solution - but it's not the only one. The indexes could be treated in parallel in their physical places where they are. That's why I called it still logical. I don't think so that I would loose all benefits of partition since an index could adapt itself when part

Re: [PERFORM] Query with limit goes from few ms to hours

2012-10-14 Thread henk de wit
Hi, For some reason the mailinglist software seems to block the email as soon as the planner details are in it, so I pasted those on pastebin.com: http://pastebin.com/T5JTwh5T Kind regards