RE: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Charles Elliott
All these titles are available on Amazon.com, and most are inexpensive if you buy them used: Beginning PHP and PostgreSQL 8: From Novice to Professional (Beginning: From Novice to Professional) PostgreSQL 8 for Windows (Database Professional's Library) Beginning PostgreSQL 8Sep 25, 2006 PostgreSQL

Re: Postgresql 8.4 optimize heavy load

2016-09-17 Thread Sten Carlsen
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: "MALE BOVINE MANURE!!!" -- Best regards Sten Carlse

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