Re: 8.3devel slower than 8.2 under read-only load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.3devel slower than 8.2 under read-only load
Date: 2007-11-26 22:07:59
Message-ID: 4305.1196114879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Are we likely to see the 3% or the 7% performance degradation with
> version 8.3?

Probably not, since it sounds like your queries are typically not as
trivial as the ones in Guillame's test case. IOW there will be some
slowdown but it's likely to be in the noise for you, and also very
likely made up by improvements elsewhere. The test case is in the
unfortunate position of not being helped materially by *any* of the work
we've done for 8.3.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-26 22:17:07 Re: Replacement Selection
Previous Message Tom Lane 2007-11-26 22:02:09 Re: Locating sharedir in PostgreSQL on Windows