Re: performance problem aftrer update from 7.1 to 7.4.2

Hallo all,

thanks for the great help.
i tried around a bit more, using different queries and so on, but
pgsql7.4 will always be somewhat slower than 7.1
finally i tested some php code , (after fixing all those wrong
integer-values of '' to 0 or null ..... ) on it
and it uses a lot of more time for fulltext search than 7.1 with less
rows in the table, also dynamis site-management
will sometimes be more than 1 second slower.
i cant explain whats wrong, i dont matter, i will update my db and live
with that, maybe optimize the querys, but theres not a lot what i can do
here ;-)

if somebody is more interested in debugging this and getting out why
performance decreases, tell me and i will send you the stuff, a test
account and all you need.
i cant examine the problem, only can help

thanks for all, your sincerely
volker

Tom Lane wrote:

>Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
>
>
>>On Thu, 22 Apr 2004, Development - multi.art.studio wrote:
>>
>>
>>>so in 7.4 seq-scan is about '1' (ms or what?) slower than 7.1
>>>
>>>
>
>
>
>>The cost numbers from explain have no direct connection to real time.
>>
>>
>
>... or at least, if your concern is poor choice of query plan, it's
>folly to treat them as being equivalent to real time. Actual runtimes
>are the things to compare.
>
>Also, I wouldn't care to bet that estimated costs from 7.1 are very
>comparable to 7.4, anyway. We rejiggered the cost models enough in
>between that it's quite likely to be a meaningless comparison.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>