Re: Postgresql 8.4 optimize for heavy select load

Поиск
Список
Период
Сортировка
От Torsten Zuehlsdorff
Тема Re: Postgresql 8.4 optimize for heavy select load
Дата
Msg-id 0eb82bd5-5f74-f737-f657-cd4ea081ef82@toco-domains.de
обсуждение исходный текст
Ответ на Re: Postgresql 8.4 optimize for heavy select load  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список 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




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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Postgresql 8.4 optimize for heavy select load
Следующее
От: julyanto SUTANDANG
Дата:
Сообщение: Re: Postgresql 8.4 optimize for heavy select load