Re: Postgresql 8.4 optimize for heavy select load

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: 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 08:23:18
Message-ID: 3a4d7d2f-bee4-2c16-0851-626f3b2e052f@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Torsten Zuehlsdorff 2016-09-19 09:09:19 Re: Postgresql 8.4 optimize for heavy select load
Previous Message Job 2016-09-19 07:40:00 Postgresql 8.4 optimize for heavy select load