Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group