Tuning for PostGreSQL Database

Alexander Leidinger Alexander at Leidinger.net
Mon Jul 21 05:16:17 PDT 2003


On Sun, 20 Jul 2003 14:53:33 -0700 (PDT)
Tom Samplonius <tom at sdf.com> wrote:

>   Well, 5.1 is considerably less crippled by Giant than 4.8.  Well,
> "crippled" is not a good description.  "Impaired" is better.  5.1 SMP
> performance is less Giant impaired than 4.8.  That's a good thing.

The critical parts for the desired operations are still covered by the
Giant lock (e.g. tcp stack, ata subsystem).

> > over takes 4.X in terms of speed, is the subject of great debate, but
> > many are optimistic that it will be at some point, just not at the
> > moment.  5.X, will however (and without much doubt), scale much better
> > than 4.X on multiple processor machines, though I'm not sure where
> > that stands at the moment in terms of being completed and should
> > likely be directed to current@ or questions@ instead of here.  -sc
> 
>   Yes, 5.1 is better on multiple CPUs.  So if 5.1 works for you, it is
> going to work faster than 4.8 on SMP.

Did you measured that, and if yes, which set of operations do you have
banchmarked?

On -current we still have reports that 5.1 is still not as fast as 4.8
(and nobody @FreeBSD.org is surprised, as the target is to first get a
stable 5.x line and after that a fast&stable one).

Bye,
Alexander.

-- 
Failure is not an option. It comes bundled with your Microsoft product.

http://www.Leidinger.net                       Alexander @ Leidinger.net
  GPG fingerprint = C518 BC70 E67F 143F BE91  3365 79E2 9C60 B006 3FE7


More information about the freebsd-performance mailing list