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 00A9A9DC8DB
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jan 2006 04:14:31 -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 63593-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jan 2006 04:14:29 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204])
	by postgresql.org (Postfix) with ESMTP id 5D54D9DC807
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Jan 2006 04:14:26 -0400 (AST)
Received: by zproxy.gmail.com with SMTP id 40so1248707nzk
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Jan 2006 00:14:27 -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=q2nMMWRbqb0bWXLxxWs0uOgADeRlXOCiw4c1eXtaBIYGUecFewl0dtCE52eXiqNBofeaSOYEMO+S8MMwQGNewFuTOWNTEJAhATScJIQXv3Ce3yFe1ePXdJG0HZgfj3GrgqI9tCPGooJtKTZANOGHdZOB8dPbiBleia0IysuFX0A=
Received: by 10.65.124.13 with SMTP id b13mr3716656qbn;
	Tue, 17 Jan 2006 00:14:27 -0800 (PST)
Received: by 10.65.59.5 with HTTP; Tue, 17 Jan 2006 00:14:27 -0800 (PST)
Message-ID: <92d3a4950601170014m352c75bes@mail.gmail.com>
Date: Tue, 17 Jan 2006 09:14:27 +0100
From: Antoine <melser.anton@gmail.com>
To: "me@alternize.com" <me@alternize.com>
Subject: Re: new to postgres (and db management) and performance already a
	problem :-(
Cc: Christopher Browne <cbbrowne@acm.org>, pgsql-performance@postgresql.org
In-Reply-To: <074b01c61b1c$538335e0$6402a8c0@iwing>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4473_31931275.1137485667200"
References: <43CC1938.7020807@gmail.com> <18875.1137451410@sss.pgh.pa.us>
	<070501c61aee$ed450560$6402a8c0@iwing>
	<22960.1137460135@sss.pgh.pa.us>
	<071801c61b05$7ea50c10$6402a8c0@iwing>
	<m3hd83sdyw.fsf@mobile.int.cbbrowne.com>
	<074b01c61b1c$538335e0$6402a8c0@iwing>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.442 required=5 tests=[AWL=0.441,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.442
X-Spam-Level: 
X-Archive-Number: 200601/217
X-Sequence-Number: 16695

------=_Part_4473_31931275.1137485667200
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 17/01/06, me@alternize.com <me@alternize.com> wrote:
>
> > Try a), b), and c) in order on the "offending" tables as they address
> > the problem at increasing cost...
>
> thanks alot for the detailed information! the entire concept of vacuum
> isn't
> yet that clear to me, so your explanations and hints are very much
> appreciated. i'll defenitely try these steps this weekend when the next
> full
> vacuum was scheduled :-)


Thanks guys, that pretty much answered my question(s) too. I have a sneakin=
g
suspicion that vacuuming won't do too much for us however... now that I
think about it - we do very little removing, pretty much only inserts and
selects. I will give it a vacuum full and see what happens.
Cheers
Antoine




--
This is where I should put some witty comment.

------=_Part_4473_31931275.1137485667200
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br><div><span class=3D"gmail_quote">On 17/01/06, <b class=3D"gmail_sen=
dername"><a href=3D"mailto:me@alternize.com">me@alternize.com</a></b> &lt;<=
a href=3D"mailto:me@alternize.com">me@alternize.com</a>&gt; wrote:</span><b=
lockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 20=
4, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
&gt; Try a), b), and c) in order on the &quot;offending&quot; tables as the=
y address<br>&gt; the problem at increasing cost...<br><br>thanks alot for =
the detailed information! the entire concept of vacuum isn't<br>yet that cl=
ear to me, so your explanations and hints are very much
<br>appreciated. i'll defenitely try these steps this weekend when the next=
 full<br>vacuum was scheduled :-)</blockquote><div><br>Thanks guys, that pr=
etty much answered my question(s) too. I have a sneaking suspicion that vac=
uuming won't do too much for us however... now that I think about it - we d=
o very little removing, pretty much only inserts and selects. I will give i=
t a vacuum full and see what happens.
<br>Cheers<br>Antoine <br></div><br></div><br><br clear=3D"all"><br>-- <br>=
This is where I should put some witty comment.

------=_Part_4473_31931275.1137485667200--