Re: tweaking PG and "machine health".

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Maksim Likharev <mlikharev(at)aurigin(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: tweaking PG and "machine health".
Date: 2003-06-30 12:24:15
Message-ID: Pine.LNX.4.33.0306300622000.13665-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 27 Jun 2003, Maksim Likharev wrote:

> I guess this too common question, but ....
> Is there any common denominator for performance tweaking, like
> if you have so much memory do so, so much connection other..
> Or even like prepackaged postgresql.conf file for small, medium or big
> machine.

There has been some discussion about including a standard set of
postgresql.conf files based on type of workload (data warehouse, high
conccurrent transactions, workstation, workgroup, intranet, etc...) but
right now it's just been that.

The starting point is to read the docs in the admin guide under server
run-time environment first:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime-config.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenéz Attila 2003-06-30 12:49:06 MemoryContextAlloc: invalid request size
Previous Message Shane Wright 2003-06-30 12:06:17 Re: weird quote bug