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 ter

Re: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Sten Carlsen
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.

RE: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Charles Elliott
SITY) library 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: Postgresql 8.4 optimize heavy load He

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 https://lists.isc.org/mailman/listi