Re: performance problem aftrer update from 7.1 to 7.4.2

["Development - multi.art.studio" <dev.null@multiartstudio.com>]

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@megazone.bigpanda.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@postgresql.org)