On 19/09/16 19:40, Job wrote:


i would please like to have some suggestions to optimize Postgres 8.4 for a 
very heavy number of select (with join) queries.
The queries read data, very rarely they write.

We probably need to see schema and query examples to help you (with EXPLAIN ANALYZE output). Also - err 8.4 - I (and others probably) will recommend you upgrade to a more recent (and supported for that matter) version - currently 9.5/9.6 - lots of performance improvements you are missing out on!

Best wishes


Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:

Reply via email to