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
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 |