On 19.09.2016 10:23, Mark Kirkwood wrote:
On 19/09/16 19:40, Job wrote:
Hello,
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!
Especially since 8.4 is out of support for 2 years:
https://www.postgresql.org/support/versioning/
Greetings,
Torsten
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
