Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 8.4 optimize for heavy select load - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Postgresql 8.4 optimize for heavy select load
Date
Msg-id 3a4d7d2f-bee4-2c16-0851-626f3b2e052f@catalyst.net.nz
Whole thread Raw
In response to Postgresql 8.4 optimize for heavy select load  (Job <Job@colliniconsulting.it>)
Responses Re: Postgresql 8.4 optimize for heavy select load  (Torsten Zuehlsdorff <mailinglists@toco-domains.de>)
Re: Postgresql 8.4 optimize for heavy select load  (julyanto SUTANDANG <julyanto@equnix.co.id>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Job
Date:
Subject: Postgresql 8.4 optimize for heavy select load
Next
From: Torsten Zuehlsdorff
Date:
Subject: Re: Postgresql 8.4 optimize for heavy select load