"Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> writes:
>> Once you're not under deadline,
>> I'd like to investigate more closely to find out why 8.1 does
>> worse than 8.0 here.
> Please tell me what I can do to help in clearing up this issue, I'd be
> very happy to help!
The first thing to do is get 8.0's EXPLAIN ANALYZE for the same query.
After we see how that differs from 8.1, we'll know what the next
question should be ...
regards, tom lane