Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group