<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><span></span></div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div><div style="direction: inherit;">You may want to explore the explain command and think about which indexes are missing.</div><br><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">--
Best regards</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">Sten Carlsen</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">No improvements come from shouting:</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">"MALE BOVINE MANURE!!!" </span></font></pre></div><div><br><div><br><br><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">--
Best regards</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">Sten Carlsen</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">No improvements come from shouting:</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">"MALE BOVINE MANURE!!!" </span></font></pre></div><div><br><br><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">--
Best regards</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">Sten Carlsen</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">No improvements come from shouting:</span></font></pre><pre class="moz-signature" cols="72"><font face=".SFUIDisplay-Regular"><span style="white-space: normal; background-color: rgba(255, 255, 255, 0);">"MALE BOVINE MANURE!!!" </span></font></pre></div>On 17 Sep 2016, at 23.23, Charles Elliott <<a href="mailto:elliott.chas@comcast.net">elliott.chas@comcast.net</a>> wrote:<br><br></div><blockquote type="cite"><div><span>All these titles are available on <a href="http://Amazon.com">Amazon.com</a>, and most are inexpensive if</span><br><span>you buy them used:</span><br><span></span><br><span>Beginning PHP and PostgreSQL 8: From Novice to Professional (Beginning: From</span><br><span>Novice to Professional)</span><br><span>PostgreSQL 8 for Windows (Database Professional's Library)</span><br><span>Beginning PostgreSQL 8Sep 25, 2006</span><br><span>PostgreSQL 8 for Windows (Database (text only) by R.Blum2007</span><br><span>Hexa Marathon Guide: PostgreSQL CE 8 Silver: MCQ on PGCES-02Aug 18, 2015</span><br><span>(???)</span><br><span>Beginning PHP and PostgreSQL 8: From Novice to Professional (Beginning: From</span><br><span>Novice to Professional) 1st Edition...Mar 2, 2006</span><br><span>PostgreSQL 8.4 Official Documentation - Volume I. The SQL Language by The</span><br><span>PostgreSQL Global Development Group</span><br><span>PostgreSQL 8.4 Official Documentation - Volume II. Server Administration by</span><br><span>The PostgreSQL Global Development</span><br><span>PostgreSQL (2nd Edition) by Korry Douglas (2005-08-05) (Not cheap)</span><br><span>PostgreSQL Replication by Zoltan (Also expensive)</span><br><span>[(PostgreSQL 8 for Windows )] [Author: Richard Blum] [Mar-2007]</span><br><span></span><br><span>If Amazon (books) are searched with 'PostgreSQL High Performance' (w/o '</span><br><span>marks), a page of interesting titles result, but all of them relate to</span><br><span>PostgreSQL 9. You could look at one from <a href="http://Amazon.com">Amazon.com</a> or at a local</span><br><span>(UNIVERSITY) library to see if any of it worked in PostgreSQL 8.4.</span><br><span></span><br><span>Charles Elliott</span><br><span></span><br><span></span><br><span>-----Original Message-----</span><br><span>From: bind-users [<a href="mailto:bind-users-bounces@lists.isc.org">mailto:bind-users-bounces@lists.isc.org</a>] On Behalf Of Job</span><br><span>Sent: Saturday, September 17, 2016 10:02 AM</span><br><span>To: <a href="mailto:bind-users@lists.isc.org">bind-users@lists.isc.org</a></span><br><span>Subject: Postgresql 8.4 optimize heavy load</span><br><span></span><br><span>Hello,</span><br><span></span><br><span>i would please like to have some suggestions to optimize Postgres 8.4 for a</span><br><span>very heavy number of select (with join) queries.</span><br><span>The queries read data, very rarely they write.</span><br><span></span><br><span>Thank you!</span><br><span>Francesco</span><br><span>_______________________________________________</span><br><span>Please visit <a href="https://lists.isc.org/mailman/listinfo/bind-users">https://lists.isc.org/mailman/listinfo/bind-users</a> to</span><br><span>unsubscribe from this list</span><br><span></span><br><span>bind-users mailing list</span><br><span><a href="mailto:bind-users@lists.isc.org">bind-users@lists.isc.org</a></span><br><span><a href="https://lists.isc.org/mailman/listinfo/bind-users">https://lists.isc.org/mailman/listinfo/bind-users</a></span><br><span></span><br><span>_______________________________________________</span><br><span>Please visit <a href="https://lists.isc.org/mailman/listinfo/bind-users">https://lists.isc.org/mailman/listinfo/bind-users</a> to unsubscribe from this list</span><br><span></span><br><span>bind-users mailing list</span><br><span><a href="mailto:bind-users@lists.isc.org">bind-users@lists.isc.org</a></span><br><span><a href="https://lists.isc.org/mailman/listinfo/bind-users">https://lists.isc.org/mailman/listinfo/bind-users</a></span><br></div></blockquote></div></body></html>