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
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
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