| From: | Torsten Zuehlsdorff <mailinglists(at)toco-domains(dot)de> |
|---|---|
| To: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Job <Job(at)colliniconsulting(dot)it>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Postgresql 8.4 optimize for heavy select load |
| Date: | 2016-09-19 09:09:19 |
| Message-ID: | 0eb82bd5-5f74-f737-f657-cd4ea081ef82@toco-domains.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | julyanto SUTANDANG | 2016-09-19 10:05:40 | Re: Postgresql 8.4 optimize for heavy select load |
| Previous Message | Mark Kirkwood | 2016-09-19 08:23:18 | Re: Postgresql 8.4 optimize for heavy select load |