Re: Postgresql 8.4 optimize for heavy select load

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!

Best wishes

Mark