Performance Tuning Document?

From: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Performance Tuning Document?
Date: 2002-03-28 16:54:47
Message-ID: Pine.LNX.4.33.0203281611570.9515-100000@sphinx.mythic-beasts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm playing with OSDB (http://osdb.sf.net/) and trying to get
the best numbers possible out of it.

I haven't been able to find anything resembling a performance
tuning document. Does such a thing exist?

Bruce's "Hardware performance tuning" guide mentions a bunch
of options but doesn't suggest what they should be set to. It
also implies that, simplistically stated, "bigger is better,
until it makes you swap", but that seems not to be always true:

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?

Any tips and tricks available? Thus far, I have tried:

tcpip_socket = true
shared_buffers = {1024,10240,102400}
max_fsm_relations = 100
max_fsm_pages = 10000
max_locks_per_transaction = 256
wal_buffers = 1024

and haven't really been able to explain the numbers (which I
will post shortly, once I have been able to try a few more
parameters).

Matthew.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo Pereira 2002-03-28 17:15:49 Sum
Previous Message Joe Conway 2002-03-28 16:53:16 Re: Escaping in C-language functions