Postgres Pro
Downloads
Home   >   mailing lists

Need help on parameters and their values to tune the postgresql database - Mailing list pgsql-performance

From Bebarta, Simanchala
Subject Need help on parameters and their values to tune the postgresql database
Date
Msg-id D566E8CF3538B54D95B925CB69CB4D2A09971CD2@inblr-exch1.eu.uis.unisys.com
Whole thread Raw
Responses Re: Need help on parameters and their values to tune the postgresql database
List pgsql-performance
Tree view

Hi,

I am doing a performance benchmarking test by using benchmarkSQL tool on postgresql 8.2.4.I need to tune the parameters to achieve an optimal performance of the postgresql database.

I have installed postgresql 8.2.4 on RHEL AS4. It is a DELL Optiplex GX620 PC with 4GB RAM.

Please suggest me which parameters I need to tune and what would be the possible values for the parameters.

Appreciate if I would get a quick response.

 

Thanks & Regards,

Simanchala

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: database tuning
Next
From: Matthew Lunnon
Date:
Subject: Limited performance on multi core server