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 Carlsen No improvements come from shouting: "MALE BOVINE MANURE!!!" > On 17 Sep 2016, at 23.23, Charles Elliott <elliott.c...@comcast.net> wrote: > > 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 8 for Windows (Database (text only) by R.Blum2007 > Hexa Marathon Guide: PostgreSQL CE 8 Silver: MCQ on PGCES-02Aug 18, 2015 > (???) > Beginning PHP and PostgreSQL 8: From Novice to Professional (Beginning: From > Novice to Professional) 1st Edition...Mar 2, 2006 > PostgreSQL 8.4 Official Documentation - Volume I. The SQL Language by The > PostgreSQL Global Development Group > PostgreSQL 8.4 Official Documentation - Volume II. Server Administration by > The PostgreSQL Global Development > PostgreSQL (2nd Edition) by Korry Douglas (2005-08-05) (Not cheap) > PostgreSQL Replication by Zoltan (Also expensive) > [(PostgreSQL 8 for Windows )] [Author: Richard Blum] [Mar-2007] > > If Amazon (books) are searched with 'PostgreSQL High Performance' (w/o ' > marks), a page of interesting titles result, but all of them relate to > PostgreSQL 9. You could look at one from Amazon.com or at a local > (UNIVERSITY) 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 > > 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/listinfo/bind-users to > unsubscribe from this list > > bind-users mailing list > bind-users@lists.isc.org > https://lists.isc.org/mailman/listinfo/bind-users > > _______________________________________________ > Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe > from this list > > bind-users mailing list > bind-users@lists.isc.org > https://lists.isc.org/mailman/listinfo/bind-users
_______________________________________________ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users
