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.
In response to
pgsql-hackers by date
|Next:||From: Laurette Cisneros||Date: 2002-03-29 00:30:00|
|Subject: pg_dump 2GB limit?|
|Previous:||From: Peter Eisentraut||Date: 2002-03-28 23:07:31|
|Subject: Re: Rough sketch for locale by default |
pgsql-general by date
|Next:||From: Paul M Foster||Date: 2002-03-28 23:35:21|
|Subject: Re: An Invoicing db design, how would you do it|
|Previous:||From: Jason Earl||Date: 2002-03-28 22:35:16|
|Subject: Re: Why are selects so slow on large tables, even|