Skip site navigation (1) Skip section navigation (2)

Please help with performance tuning on Postgres

From: Greg Youngblood <YoungblG(at)houstoncellular(dot)com>
To: "'pgsql-admin(at)postgres(dot)org'" <pgsql-admin(at)postgres(dot)org>, "'pgsql-novice(at)postgres(dot)org'" <pgsql-novice(at)postgres(dot)org>, "'pgsql-general(at)postgres(dot)org'" <pgsql-general(at)postgres(dot)org>
Subject: Please help with performance tuning on Postgres
Date: 1998-10-02 19:09:06
Message-ID: 2B9713A99045D211BB4E0008C75668690B1124@SCORPEXC1.houstoncell.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
I have a database running fine, however, it is purely stock configuration. I
would like to fine tune it for better performance and to control memory
usage.

I have seen people refer to restricting the number of back end processes,
and fine tuning maximum memory consumption as well as other items.

I've read the man pages, and a few options look promising, such as -B on
postmaster and -S on postgres. However, I can't find anything that explains
what exactly those options will do, and the ramifications of changing them
away from defaults.

I also can't find any mention of restricting the number of simultaneous
connections. Or, restricting the number of back end processes that can be
run.

The database will have a lot of information, but has no need to run more
than maybe 4 to 12 backend processes. I would estimate that it wouldn't need
more than 6 unless special circumstances arose.

This database is going to sit behind a web based front end. There won't be a
lot of simultaneous queries on the system, in normal operations. The web
will be used as a query tool. Data modifications and updates will probably
be via Access and ODBC, but that may change to some web based modifications
and updates at a later time.

Does anyone have any pointers to fine tuning memory and performance details
of Postgres? I would really like to find something that documents not only
what things do, but what ramifications of certain operations are. I want to
understand the performance tuning, not just copy someone's prewritten
instructions. 

Thanks.
Greg

Gregory S. Youngblood
ext 2164
 
 




pgsql-admin by date

Next:From: Ricardo AG AlmeidaDate: 1998-10-02 19:41:10
Subject: pg_dump
Previous:From: Melanie Renee NelsonDate: 1998-10-02 18:59:06
Subject: compiling on SGIs

pgsql-general by date

Next:From: TaralDate: 1998-10-02 21:12:19
Subject: RE: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Previous:From: Bruce MomjianDate: 1998-10-02 17:58:25
Subject: Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group