Postgresql 8.4 optimize heavy load

[Christoph Moench-Tegeder]

## Job (Job at colliniconsulting.it):

> i would please like to have some suggestions to optimize Postgres 8.4
> for a very heavy number of select (with join) queries.

1. PostgreSQL 8.4 has been EOL for over two years. Newer versions do
   not only receive bugfixes, but they have improvements in terms of
   performance and concurrency.
   https://www.postgresql.org/support/versioning/
2. Make sure your schema is sane and indexed for your use case.
3. Check your configuration - in your case, the most important
   setting is "shared_buffers", followed by "work_mem".
4. You question would me more appropriate for the PostgreSQL
   mailing lists.

If you need more help, I'd refer you to my italian colleagues -
ask for details.

Regards,
Christoph

-- 
Spare Space