Re: Postgres slower than MS ACCESS

From: Peter Childs <peterachilds(at)gmail(dot)com>
To: Jay Greenfield <jag(at)timberline(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres slower than MS ACCESS
Date: 2006-02-16 13:32:34
Message-ID: a2de01dd0602160532y37de192dv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 15/02/06, Jay Greenfield <jag(at)timberline(dot)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 will
find "Tools -> Database Utils -> Compact Database" preforms a simular
purpose and is just as important as I've seen many Access Databases bloat in
my time.

Peter Childs

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2006-02-16 13:38:45 Re: [PERFORM] qsort again
Previous Message Ron 2006-02-16 13:22:55 Re: qsort again (was Re: [PERFORM] Strange Create Index