X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7DD159DC8A9 for ; Wed, 25 Jan 2006 14:58:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47192-06 for ; Wed, 25 Jan 2006 14:58:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.195]) by postgresql.org (Postfix) with ESMTP id 5A3E59DC891 for ; Wed, 25 Jan 2006 14:58:48 -0400 (AST) Received: by uproxy.gmail.com with SMTP id s2so305863uge for ; Wed, 25 Jan 2006 10:58:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Em0VgS8Di+PQdVS3KQGrxdpBD9d/dj1pm5X5zkoKnshG9b6P7yt9l6g1EIxodFFXEssfiZ7ZpZO0xner514dn7jK6KCb8fwJTrLQhR0DpNhN4OXtZMqt8UXIoYeiqckLUgsd9pX9IxXG+YjohYJLdSv8qfrxlaAN2MvbwczdEKc= Received: by 10.66.241.16 with SMTP id o16mr463997ugh; Wed, 25 Jan 2006 10:58:48 -0800 (PST) Received: by 10.66.224.6 with HTTP; Wed, 25 Jan 2006 10:58:47 -0800 (PST) Message-ID: Date: Wed, 25 Jan 2006 18:58:47 +0000 From: Guido Barosio To: Dario Brignardello Subject: Re: Where is my bottleneck? Cc: arnaulist@andromeiberica.com, pgsql-admin@postgresql.org, John Jensen In-Reply-To: <45dd8dbe0601251003w66cf12c0u4954bca165fb75e2@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_498_11158253.1138215527794" References: <43D7ADE3.1050803@andromeiberica.com> <45dd8dbe0601251003w66cf12c0u4954bca165fb75e2@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.077 required=5 tests=[AWL=-0.256, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.077 X-Spam-Level: * X-Archive-Number: 200601/288 X-Sequence-Number: 20376 ------=_Part_498_11158253.1138215527794 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Arnu, Take a look at contrib/pg_buffers and contrib/pgstattuple also!! Regards, Guido. (dariussss) On 1/25/06, Dario Brignardello wrote: > > Hi, Arnu, > > > > > > The parameters related with memory usage of postgresql.conf all are the > > default values (I haven't changed any value in the postgresql.conf file= ) > > Well, there is actually plenty of room to optimize there, I would suggest > to go to > http://www.postgresql.org/docs/7.4/interactive/runtime-config.html#RUNTIM= E-CONFIG-RESOURCE > > > and take a look, specially the values for shared_buffers and sort_mem > should be higher (mind you, you also have to tune your kernel parameters = or > your engine will not start, so be careful :-) ) > > > > I know that I can tune my queries, but I think I could get more > >performance from the hardware I have. > > Actually you can, but a bad query is always a bad > query, even when runing on big iron, so you should be sure you > are not wasting hw resources, specially if those are scarce :-) > > > > My settings are, do I should change anything else? > > > > # - Query/Index Statistics Collector - > > > stats_start_collector =3D true > > stats_command_string =3D true > > #stats_block_level =3D false > > stats_row_level =3D true > > #stats_reset_on_server_start =3D true > > Take a look at the pg_stat_* views, to see what could be out off the way. > To an explanation of the statistics views, check: > http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.html > > Hope it helps. > Best regards > Dario > > > -- > Atte: Dario Brignardello > > -- /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ----------------------------------------------------------------- ------=_Part_498_11158253.1138215527794 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi Arnu,
 
   Take a look at contrib/pg_buffers and contrib/pgstattuple= also!!
 
Regards,
Guido. (dariussss)
 


 
On 1/25/06, = Dario Brignardello <dbrignar@g= mail.com> wrote:
Hi, Arnu,
<= br>
>
> The parameters related with memory usage of postgresql= .conf all are the
> default values (I haven't changed any value in the pos= tgresql.conf file)

Well, there is actually plenty of room to = optimize there, I would suggest to go to  
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html#RUNTIME-= CONFIG-RESOURCE

and take a look, specially the values for share= d_buffers and sort_mem should be higher (mind you, you also have to tune yo= ur kernel parameters or your engine will not start, so be careful :-) )=20
 

>   I know that I can tune= my queries, but I think I could get more
>performance from the hard= ware I have.

Actually you can, but a bad query is always a ba= d query, even when runing on big iron, s= o you should be sure you are not wasting=  hw resources, specially if those are scarce :-)=20


> My settings are, do I should change anyt= hing else?
>
> # - Query/Index Statistics Collector -

&g= t; stats_start_collector =3D true
> stats_command_string =3D true
= > #stats_block_level =3D false=20
> stats_row_level =3D true
> #stats_reset_on_server_start =3D= true

Take a look at the pg_stat_* views, to see wh= at could be out off the way. To an explanatio= n of the statistics views, check:
http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.html
Hope it helps.
Best regards
Dario


= --
Atte: Dario Brignardello




--
/"\   ASCII Ribbon Campaign  .
\ / -= NO HTML/RTF in e-mail  .
X  - NO Word docs in e-mai= l .
/ \ ----------------------------------------------------------------= -=20 ------=_Part_498_11158253.1138215527794--