R: Postgresql 8.4 optimize heavy load

[Job]

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 [stenc at s-carlsen.dk]
Inviato: domenica 18 settembre 2016 0.03
A: Job
Cc: bind-users at 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.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