X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4595E11F6D27 for ; Sun, 9 Apr 2006 07:42:40 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 2.452 X-Spam-Level: ** X-Spam-Status: No, score=2.452 required=5 tests=[AWL=0.120, FROM_LOCAL_NOVOWEL=2.331, HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 1bxFyy3gNHpB for ; Sun, 9 Apr 2006 07:42:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by postgresql.org (Postfix) with ESMTP id 3ECFC11F6D1C for ; Sun, 9 Apr 2006 07:42:36 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id m7so749872nzf for ; Sun, 09 Apr 2006 03:42:36 -0700 (PDT) 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=Yeh8szcvinQ+XjDfxeDkguHW3mF+9VPmIHzkEAa11NIFA7FiwLHS8wm4/tnkJcSaZ1ew2if8L5aM4p78D9uFtt2VazcUhFc/lJxJ4nFsWVj66fxyhvtix2aDBwGdAUXGvlFvjHWpfjvcYjf502UzjvY0kW/wIdIjWYuVHjsyOyU= Received: by 10.36.60.13 with SMTP id i13mr191412nza; Sun, 09 Apr 2006 03:42:36 -0700 (PDT) Received: by 10.36.153.7 with HTTP; Sun, 9 Apr 2006 03:42:36 -0700 (PDT) Message-ID: Date: Sun, 9 Apr 2006 14:42:36 +0400 From: Luckys To: "Doron Baranes" Subject: Re: Cc: pgsql-performance@postgresql.org In-Reply-To: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18802_18168350.1144579356332" References: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il> X-Archive-Number: 200604/174 X-Sequence-Number: 18258 ------=_Part_18802_18168350.1144579356332 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline It'd be helpful if posted with the EXPLAIN of the slow running queries on the respective table. cool. L. On 4/9/06, Doron Baranes wrote: > > Hi > > > > I am new at postgres and I'm having performance issues. > > I am running on postgres 7.4.6 on a pineapp with 512MB RAM. > > I did a database vacuum analyze and rebuild my indexes. > > When I perform queries on tables of 2M-10M of rows it takes several > minutes and > > I see at sar and top that the cpu and memory is heavily used. > > > > I would be glad for guidance on server parameters or other configurations > which would help. > > > > 10x. > > > Doron. > ------=_Part_18802_18168350.1144579356332 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
It'd be helpful if posted with the EXPLAIN of the slow running queries= on the respective table.
 
cool.
L.

 
On 4/9/06, D= oron Baranes <doron.bar= anes@dbnet.co.il> wrote:

Hi

 

I am new= at postgres and I'm having performance issues.

I am run= ning on postgres 7.4.6 on a pineapp with 512MB RAM.

I did a = database vacuum analyze and rebuild my indexes.

When I p= erform queries on tables of 2M-10M of rows it takes several minutes and

I see at= sar and top that the cpu and memory is heavily used.

 

I would = be glad for guidance on server parameters or other configurations which wou= ld help.

 

10x.


Doro= n.


------=_Part_18802_18168350.1144579356332--