Re: PostgreSQL Config.

Ramesh Patel wrote:
> Dear All
>
> I have Redhat 9.0 and i use Postgresql and PHP .
> This Database ranning last two year. now i have some speed problem.
> Now i am new in Postgresql so How to Config a PostgreSQL.conf file.
>
> my Hardver is
> P IV server, 1 GB RAM , 72 GB SCGI HDD.
> and I am use Web Application.
> if Possible then give me Config file.

The best I can do is to point you to:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

That's a good introduction to performance tuning, and just the first
section can help with lots of problems.

Before that though, how often do you run vacuum/analyse? H you've
noticed any problems there?

--
Richard Huxton
Archonet Ltd