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 761689DC83D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Feb 2006 09:32:34 -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 90740-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Feb 2006 09:32:37 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198])
	by postgresql.org (Postfix) with ESMTP id 3374D9DC82A
	for <pgsql-performance@postgresql.org>;
	Thu, 16 Feb 2006 09:32:31 -0400 (AST)
Received: by zproxy.gmail.com with SMTP id v1so170591nzb
	for <pgsql-performance@postgresql.org>;
	Thu, 16 Feb 2006 05:32:35 -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=a4AROPv1cshXKE6wgKzSrWywEj8K3OZxTAs8+D48gh5qlbM4JwKzDdyRmSPfzN3mgM0TM7Ih5DVLxUr4Vs/Sk5JVUvDC3W4XivO4xE+hLDT/wSOheGBEZ6WVq5KdLPgVBXXM8eBLHRt1wlcw5PSZEBBel5QHOMaXDLdFRx9NTyI=
Received: by 10.65.230.4 with SMTP id h4mr716516qbr;
	Thu, 16 Feb 2006 05:32:34 -0800 (PST)
Received: by 10.64.233.17 with HTTP; Thu, 16 Feb 2006 05:32:34 -0800 (PST)
Message-ID: <a2de01dd0602160532y37de192dv@mail.gmail.com>
Date: Thu, 16 Feb 2006 13:32:34 +0000
From: Peter Childs <peterachilds@gmail.com>
To: Jay Greenfield <jag@timberline.ca>
Subject: Re: Postgres slower than MS ACCESS
Cc: pgsql-performance@postgresql.org
In-Reply-To: <200602152129.k1FLTpiO008671@timberline.ca>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_18495_29586099.1140096754733"
References: <24B89C42-C597-4571-8BD1-A89073C3C035@torgo.978.org>
	<200602152129.k1FLTpiO008671@timberline.ca>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.768 required=5 tests=[AWL=0.767,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.768
X-Spam-Level: 
X-Archive-Number: 200602/245
X-Sequence-Number: 17231

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

On 15/02/06, Jay Greenfield <jag@timberline.ca> wrote:
>
>
> I've been vacuuming between each test run.
>
> Not vacuuming results in times all the way up to 121 minutes.  For a
> direct
> comparison with Access, the vacuuming time with Postgres should really be
> included as this is not required with Access.



Hmm but then you would have to include Access Vacuum too I'll think you wil=
l
find "Tools -> Database Utils -> Compact Database" preforms a simular
purpose and is just as important as I've seen many Access Databases bloat i=
n
my time.

Peter Childs

------=_Part_18495_29586099.1140096754733
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 15/02/06, <b class=3D"gmail_sen=
dername">Jay Greenfield</b> &lt;<a href=3D"mailto:jag@timberline.ca">jag@ti=
mberline.ca</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D=
"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padd=
ing-left: 1ex;">
<br>I've been vacuuming between each test run.<br><br>Not vacuuming results=
 in times all the way up to 121 minutes.&nbsp;&nbsp;For a direct<br>compari=
son with Access, the vacuuming time with Postgres should really be<br>inclu=
ded as this is not required with Access.
</blockquote><div><br>
<br>
Hmm but then you would have to include Access Vacuum too I'll think you
will find &quot;Tools -&gt; Database Utils -&gt; Compact Database&quot; pre=
forms
a simular purpose and is just as important as I've seen many Access
Databases bloat in my time.<br>
<br>
Peter Childs <br>
</div></div><br>

------=_Part_18495_29586099.1140096754733--