## Job (j...@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.
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
If you need more help, I'd refer you to my italian colleagues -
ask for details.
Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe
from this list
bind-users mailing list