Postgresql 8.4 optimize heavy load

[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 Carlsen
No improvements come from shouting:
"MALE BOVINE MANURE!!!"
> On 17 Sep 2016, at 23.23, Charles Elliott <elliott.chas at 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-bounces at lists.isc.org] On Behalf Of Job
> Sent: Saturday, September 17, 2016 10:02 AM
> To: bind-users at 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 at 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 at lists.isc.org
> https://lists.isc.org/mailman/listinfo/bind-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/bind-users/attachments/20160918/70de36dc/attachment.html>