Postgres slower than MS ACCESS

From: "Jay Greenfield" <jag(at)timberline(dot)ca>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Postgres slower than MS ACCESS
Date: 2006-02-14 15:51:23
Message-ID: 200602141551.k1EFpN6F020512@timberline.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I am running some simple queries to benchmark Postgres 8.1 against MS Access
and Postgres is 2 to 3 times slower that Access.

Hardware:

Dell Optiplex GX280

P4 3.20 GHz

3GB RAM

Windows XP SP1

Database has one table with 1.2 million rows

Query:

UPDATE ntdn SET gha=area/10000

I could post the EXPLAIN ANALYZE results but its 4,000+ lines long

I've run various tests on a number of Postgres parameters; none of which
have come close to Access' time of 5.00 min. Postgres times range between
24 min and 121 min.

Some of the Postgres variables and ranges I've tested.

work_mem: 1,000 to 2,000,000

temp_buffers: 1,000 to 10,000

shared_buffers: 1,000 to 64,000

sort_mem: 1,024,000

fsync on / off

Why does Access run so much faster? How can I get Postgres to run as fast
as Access?

Thanks,

Jay

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message martial.bizel 2006-02-14 16:03:38 Re: out of memory
Previous Message Tom Lane 2006-02-14 15:32:49 Re: out of memory