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