Re: Optimizing POSTGRESQL config

Joanne,

> Attached to this email is the configuration file that
> we are currently using for POSTGRESQL
> (postgresql.txt).  We are using Apache webserver
> together with PHP and PostgreSQL 7.3.2.  Our test
> server has the following specs:  AMD Athlon 1.2 Gz
> with 128 MB of ram. Any help and suggestions on the
> matter would be very much appreciated.  Thank you.

Buy more RAM.   In my experience, Apache tends to use about 128mb by itself
under moderate concurrent user load, causing it to fight with PostgreSQL for
RAM.   I think you'll find that doubling your RAM will quintuple your
PostgreSQL performance on large queries.


--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology     josh@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco