R: Postgresql 8.4 optimize heavy load

2016-09-19 Thread Job
: Postgresql 8.4 optimize heavy load You may want to explore the explain command and think about which indexes are missing. -- Best regards Sten Carlsen No improvements come from shouting: "MALE BOVINE MANURE!!!" -- Best regards Sten Carlsen No improvements come from shouting: &q

Re: Postgresql 8.4 optimize heavy load

2016-09-18 Thread Christoph Moench-Tegeder
## Job (j...@colliniconsulting.it): > i would please like to have some suggestions to optimize Postgres 8.4 > for a very heavy number of select (with join) queries. 1. PostgreSQL 8.4 has been EOL for over two years. Newer versions do not only receive bugfixes, but they have improvements in

Re: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Sten Carlsen
to see if any of it worked in PostgreSQL 8.4. > > Charles Elliott > > > -Original Message- > From: bind-users [mailto:bind-users-boun...@lists.isc.org] On Behalf Of Job > Sent: Saturday, September 17, 2016 10:02 AM > To: bind-users@lists.isc.org > Subject: Postgr

RE: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Charles Elliott
if any of it worked in PostgreSQL 8.4. Charles Elliott -Original Message- From: bind-users [mailto:bind-users-boun...@lists.isc.org] On Behalf Of Job Sent: Saturday, September 17, 2016 10:02 AM To: bind-users@lists.isc.org Subject: Postgresql 8.4 optimize heavy load Hello, i would please

Postgresql 8.4 optimize heavy load

2016-09-17 Thread Job
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 ___ Please visit