Postgresql 8.4 optimize for heavy select load

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Postgresql 8.4 optimize for heavy select load
Date: 2016-09-19 07:40:00
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054C149843@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thank you!
Francesco

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2016-09-19 08:23:18 Re: Postgresql 8.4 optimize for heavy select load
Previous Message Knels, Udo 2016-09-19 07:29:48 Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher