Re: why is the db so slow? - Mailing list pgsql-performance

Becky Neville wrote:
> Are there any parameters I can set to speed things up?
>

You haven't given us much in the way of specifics to work with, but here
is a short list of things to try/do:

- read (amongst other things):
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/runtime-config.html

- run "VACUUM ANALYZE" on your database
- adjust key default configuration settings:
   shared_buffers = 1000 (or maybe 2000 or even 4000 -- above that you'd
                          need root access, and it might not help anyway)
   sort_mem = 8192 (depending on the amount of RAM in the server, this
                    might be too high/low, but start with something in
                    the 4000 to 8000K range)
- run "EXPLAIN ANALYZE" on your queries, and send in the results and the
table structure details to the list.

HTH,

Joe