From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Job <Job@colliniconsulting.it>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Postgresql 8.4 optimize for heavy select load
Date: Mon, 19 Sep 2016 20:23:18 +1200
Message-ID: <3a4d7d2f-bee4-2c16-0851-626f3b2e052f@catalyst.net.nz> (raw)
In-Reply-To: <88EF58F000EC4B4684700C2AA3A73D7A08054C149843@W2008DC01.ColliniConsulting.lan>
References: <88EF58F000EC4B4684700C2AA3A73D7A08054C149843@W2008DC01.ColliniConsulting.lan>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, Job@colliniconsulting.it
Subject: Re: Postgresql 8.4 optimize for heavy select load
In-Reply-To: <3a4d7d2f-bee4-2c16-0851-626f3b2e052f@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox