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

Re: Performance Tuning Document?

From: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
To: "Riebs, Andy" <Andy(dot)Riebs(at)compaq(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance Tuning Document?
Date: 2002-03-28 23:15:24
Message-ID: Pine.LNX.4.33.0203282314490.27310-100000@sphinx.mythic-beasts.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Thu, 28 Mar 2002, Riebs, Andy wrote:

> > Under the "crossSectionTests(Mixed IR)" part of an OSDB run, a
> > large number of shared_buffers causes severe slowdown on one of
> > the tests -- it goes from a little over 200 seconds to nearly
> > 2000.  I suspect internal lock contention, or maybe it's just
> > that the read() path in Linux is quicker than PG's own cache?
>
> Matthew, are you using the --postgresql=no_hash_index option for OSDB?
> It's conceivable that you are hitting an artifact of the hash index
> problem here.

Ah, that would make a lot of sense.  I'll do a run again with
that option and see what turns up.

Thanks,
Matthew.


In response to

Responses

pgsql-hackers by date

Next:From: Laurette CisnerosDate: 2002-03-29 00:30:00
Subject: pg_dump 2GB limit?
Previous:From: Peter EisentrautDate: 2002-03-28 23:07:31
Subject: Re: Rough sketch for locale by default

pgsql-general by date

Next:From: Paul M FosterDate: 2002-03-28 23:35:21
Subject: Re: An Invoicing db design, how would you do it
Previous:From: Jason EarlDate: 2002-03-28 22:35:16
Subject: Re: Why are selects so slow on large tables, even

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