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