Re: Postgresql 8.4 optimize for heavy select load

Поиск
Список
Период
Сортировка
От julyanto SUTANDANG
Тема Re: Postgresql 8.4 optimize for heavy select load
Дата
Msg-id CAGu3fEQqM=PoS05bQVXrHmNtLhQtx1hRu5QXXvArwjKWhbE_bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql 8.4 optimize for heavy select load  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance
You might wanted to upgrade to new  version 9.5 with small effort by using pg_upgrade, 
we have done upgrading and achieve more than 20x faster from 8.4 to 9.5 (it depends on the type of sql statement actually)

Jul.



Julyanto SUTANDANG

Equnix Business Solutions, PT
(An Open Source and Open Mind Company)
www.equnix.co.id
Pusat Niaga ITC Roxy Mas Blok C2/42.  Jl. KH Hasyim Ashari 125, Jakarta Pusat
T: +6221 22866662 F: +62216315281 M: +628164858028


Caution: The information enclosed in this email (and any attachments) may be legally privileged and/or confidential and is intended only for the use of the addressee(s). No addressee should forward, print, copy, or otherwise reproduce this message in any manner that would allow it to be viewed by any individual not originally listed as a recipient. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is strictly prohibited. If you have received this communication in error, please immediately notify the sender and delete this message.Unless it is made by the authorized person, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of PT Equnix Business Solutions.

On Mon, Sep 19, 2016 at 3:23 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> 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!

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Torsten Zuehlsdorff
Дата:
Сообщение: Re: Postgresql 8.4 optimize for heavy select load
Следующее
От: Mike Broers
Дата:
Сообщение: query against single partition uses index, against master table does seq scan