colin wrote:
> My key configuration in postgresql.conf
>
> listen_addresses = '*'
> max_connections = 400
> shared_buffers = 512MB
> temp_buffers = 200MB
> work_mem = 1GB
> maintenance_work_mem = 512MB
You didn't say anything about your hardware or OS. For that to be a
somewhat reasonable configuration you would need to be running on
Windows with about 1TB of RAM and about 70 disk spindles. If your
runtime environment doesn't look like that, you need to make some
adjustments. Rather than guess at it, please tell us your OS, the
exact version of PostgreSQL (the output of `SELECT version();`), and
describe your hardware (RAM, processors, storage array, RAID
controller, etc.).
With the additional information, people can make more useful
suggestions.
-Kevin