Thank you to everybody and excuse me, first of all. I wrote requests for postgresql (even if connected with Bind-DLZ) in the wrong Group!
Thank you! Francesco Da: Sten Carlsen [st...@s-carlsen.dk] Inviato: domenica 18 settembre 2016 0.03 A: Job Cc: bind-users@lists.isc.org Oggetto: Re: 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: "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