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