Re: 8.3devel slower than 8.2 under read-only load - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.3devel slower than 8.2 under read-only load
Date
Msg-id 26771.1195710295@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.3devel slower than 8.2 under read-only load  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: 8.3devel slower than 8.2 under read-only load  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers
"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> I'm not saying my benchmark is perfectly relevant: I made it
> excessively simple on purpose. I just see a general slow down which is
> quite consistent accross all the tests I did (with pgbench or the
> application) and I'd really like to know if it's just my case on this
> particular box or something more general.

Are you examining only "trivial" queries?  I've been able to identify a
couple of new planner hotspots that could explain some slowdown if the
planning time is material compared to the execution time.  If you're
seeing a slowdown on queries that run for awhile, that would be
something else ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load
Next
From: cinu
Date:
Subject: run_build.pl ~ By Andrew Dunstan