Pavel Stehule wrote:
> 2010/11/21 Humair Mohammed :
>> shared_buffers = 2
> shared_buffers = 2 ???
Yeah, if that's not a typo, that's a very serious misconfiguration.
With 8 GB of RAM in the machine, this should probably be set to
somewhere between 200 MB and 2 GB, depending on your workload and
what else is running on the machine.
Please read through this page and make use of the information:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
-Kevin