pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 8.4 optimize for heavy select load
4+ messages / 4 participants
[nested] [flat]
* Postgresql 8.4 optimize for heavy select load
@ 2016-09-19 07:40 Job <Job@colliniconsulting.it>
0 siblings, 1 reply; 4+ messages in thread
From: Job @ 2016-09-19 07:40 UTC (permalink / raw)
To: 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql 8.4 optimize for heavy select load
@ 2016-09-19 08:23 Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
parent: Job <Job@colliniconsulting.it>
0 siblings, 2 replies; 4+ messages in thread
From: Mark Kirkwood @ 2016-09-19 08:23 UTC (permalink / raw)
To: Job <Job@colliniconsulting.it>; 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql 8.4 optimize for heavy select load
@ 2016-09-19 09:09 Torsten Zuehlsdorff <mailinglists@toco-domains.de>
parent: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
1 sibling, 0 replies; 4+ messages in thread
From: Torsten Zuehlsdorff @ 2016-09-19 09:09 UTC (permalink / raw)
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; Job <Job@colliniconsulting.it>; 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql 8.4 optimize for heavy select load
@ 2016-09-19 10:05 julyanto SUTANDANG <julyanto@equnix.co.id>
parent: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
1 sibling, 0 replies; 4+ messages in thread
From: julyanto SUTANDANG @ 2016-09-19 10:05 UTC (permalink / raw)
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; +Cc: Job <Job@colliniconsulting.it>; 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-09-19 10:05 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-19 07:40 Postgresql 8.4 optimize for heavy select load Job <Job@colliniconsulting.it>
2016-09-19 08:23 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2016-09-19 09:09 ` Torsten Zuehlsdorff <mailinglists@toco-domains.de>
2016-09-19 10:05 ` julyanto SUTANDANG <julyanto@equnix.co.id>
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