[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] tweaking PG and "machine health".
From:       "scott.marlowe" <scott.marlowe () ihs ! com>
Date:       2003-06-30 12:24:15
[Download RAW message or body]

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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
[prev in list] [next in list] [prev in thread] [next in thread]