Re: Performance tuning in PostgreSQL

From: Abhishek Sharma <abhisheks(at)dpsl(dot)net>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>, dev(at)archonet(dot)com
Subject: Re: Performance tuning in PostgreSQL
Date: 2003-03-26 23:03:23
Message-ID: JKEIKAKAPLPIEBFPIFGGIEDACAAA.abhisheks@dpsl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

Tx for your reply.

Is there any way to determine the size of a process per connection.

What is it dependent on ?

What variables affect the size of a process by a user accessing a table in
the database ?

Postgresql can be configured with a --max-backends options which means the
no. of connections which can be established at any given time to the
server,which also means that there will be an equal no. of process.

In my opinion there should be some computation with regards to the amount of
RAM or shared buffer space and the no. of processes and size of these
processes.

I am using 256 MB Ram on a RHL 8 system. I have made the shared buffer space
190 MB i.e.. 75 % of my system. My database is going to be almost 80 GB.

Advice needed.

Tx,
Best regards,

Abhishek.

-----Original Message-----
From: dev(at)archonet(dot)com [mailto:dev(at)archonet(dot)com]
Sent: Tuesday, March 25, 2003 11:54 PM
To: Abhishek Sharma
Cc: Pgsql-General
Subject: Re: [GENERAL] Performance tuning in PostgreSQL

> Can someone tell me the various aspects of Hardware for performance tuning
> in PostgreSQL 7.3 on a RHL 8 server.
>
> How can I determine the required hardware configuration(CPUs,RAM,Shared
> Buffer Space,OS TCP/IP ports) for n number of connections or n number of
> users accessing the database?

The bad news is there's only one way and that's to test. Without knowing
how much data you have, in what tables and how you are querying/updating
it you really can't say much useful.

A few points though.

CPU: PostgreSQL will use multiple CPUs but one query runs on only one CPU.
RAM: more is better, pretty much always
Disk: fast and see the archives for details on placing the WAL on its own
disk.
Tuning: there's a performance mailing list, and some stuff on
techdocs.postgresql.org

Hope that's some use

- Richard Huxton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-26 23:14:19 Re: Please help with this error message
Previous Message Dennis Gearon 2003-03-26 22:57:46 Re: indexes