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
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
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 ANALY
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
