postgresql.conf - Mailing list pgsql-performance

From scott.marlowe
Subject postgresql.conf
Date
Msg-id Pine.LNX.4.33.0307301028220.24999-100000@css120.ihs.com
Whole thread Raw
Responses Re: postgresql.conf
Re: postgresql.conf
List pgsql-performance
I'm looking at doing the example postgresql.conf files for the 7.4
release. So far, the catagories we have would be a matrix of:

-------------- Large Machine -- Small Machine
Webserver
OLAP
OLTP
Workstation

But likely only one entry for workstation.

anyone have any advice on what they use in which situations and what we
should include in the examples?

I'm guessing OLTP needs things like FSM cranked up,
OLAP (a for analytical) needs more shared buffers and sort memory
Webserver might be better served just slightly higher values than default
but well under those of either OLTP or OLAP...





pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Getting Started Guide?
Next
From: Josh Berkus
Date:
Subject: Re: [SQL] function returning setof performance question