Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id C69B563557F
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon,  2 Nov 2009 10:34:27 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 63601-03-5
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon,  2 Nov 2009 14:34:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id AE681634779
	for <pgsql-general@postgresql.org>;
	Mon,  2 Nov 2009 10:33:56 -0400 (AST)
Received: by bwz5 with SMTP id 5so6530968bwz.3
	for <pgsql-general@postgresql.org>;
	Mon, 02 Nov 2009 06:33:54 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=JITmMMUhrPaveGT8frwh7w/EbeZjAehwwqsCLBYDcBM=;
	b=soPHaCETQmnv8pGOHwvtJhs637Pe3DhBAnMA5Fl+tfm+RzcLedURwUP4JmyC0TEWjt
	AZ6mD5pRzemlON0JWUxNoMbNXQ3okfbH2i3Kfbnjt2ZaaNRexqQVY3bZ/X2ca7E/2VLT
	uIuomX2pKtU5Qvs2MHuhgnsp+tBCd6OfC+Pyk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=GJebhR1hi+R24YqnelXLMgR/j0seFTN23BlE7ouiQQB9q2DoAJjSpjLQIqm+u3mM2l
	sSPI8Fkzkx5ygwY3J6gcvVsR++2svG7AVcXhKLlMx9JgZWctcCSz6tKZREohogca/B2Q
	b7p4plCZhCQfkcFAeD9zXW1W2f6QLQGKhPJ18=
MIME-Version: 1.0
Received: by 10.204.33.193 with SMTP id i1mr3959780bkd.75.1257172432142; Mon,
	02 Nov 2009 06:33:52 -0800 (PST)
In-Reply-To: <c09b5d640911020623k2c0e0fe5xdf8573a0fd8ca4c3@mail.gmail.com>
References: <c09b5d640911020616t7177a7b9sb4b5f285d99e7c05@mail.gmail.com>
	<2f4958ff0911020619yc7ed6e6u74ff6a01cb7ce98c@mail.gmail.com>
	<c09b5d640911020623k2c0e0fe5xdf8573a0fd8ca4c3@mail.gmail.com>
Date: Mon, 2 Nov 2009 14:33:52 +0000
Message-ID: <2f4958ff0911020633o3be6d49dy9c22da9c322b0e9f@mail.gmail.com>
Subject: Re: [PERFORM] Problem with database performance, Debian 4gb ram ?
From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com>
To: Grant Masan <grant.massan@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary=000325557a763d41780477644450
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.353 tagged_above=-10 required=5 tests=AWL=0.245,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/59
X-Sequence-Number: 154988

--000325557a763d41780477644450
Content-Type: text/plain; charset=UTF-8

2009/11/2 Grant Masan <grant.massan@gmail.com>

> Size is "6154 MB". I have checked all queries, and those are as good as
> they can be in this situation. You think that this confs doesn't make really
> no difference at all ?
>
> you gotta hit 'reply all' next time ;)
configuration makes difference, but you need to know what is your issue
before you start changing stuff randomly.


try using pg_tune , that should give you good config for your hardware.


-- 
GJ

--000325557a763d41780477644450
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">2009/11/2 Grant Masan <span dir=3D"ltr">=
&lt;<a href=3D"mailto:grant.massan@gmail.com">grant.massan@gmail.com</a>&gt=
;</span><br><blockquote class=3D"gmail_quote" style=3D"border-left: 1px sol=
id rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Size is &quot;6154 MB&quot;. I have checked all queries, and those are as g=
ood as they can be in this situation. You think that this confs doesn&#39;t=
 make really no difference at all ?<br><br></blockquote><div>you gotta hit =
&#39;reply all&#39; next time ;)<br>
configuration makes difference, but you need to know what is your issue bef=
ore you start changing stuff randomly.<br><br><br>try using pg_tune , that =
should give you good config for your hardware. <br><br></div></div><br>
-- <br>GJ<br>

--000325557a763d41780477644450--