Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Markus Wollny" <Markus.Wollny@xxxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux