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

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: (view raw, whole thread or download thread mbox)
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.  



Dell Optiplex GX280

P4 3.20 GHz


Windows XP SP1


Database has one table with 1.2 million rows



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?












pgsql-performance by date

Next:From: martial.bizelDate: 2006-02-14 16:03:38
Subject: Re: out of memory
Previous:From: Tom LaneDate: 2006-02-14 15:32:49
Subject: Re: out of memory

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