From: Jay Greenfield <jag@timberline.ca>
To: pgsql-performance@postgresql.org
Subject: Postgres slower than MS ACCESS
Date: Tue, 14 Feb 2006 07:51:23 -0800
Message-ID: <200602141551.k1EFpN6F020512@timberline.ca> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jag@timberline.ca
Subject: Re: Postgres slower than MS ACCESS
In-Reply-To: <200602141551.k1EFpN6F020512@timberline.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox