From: Jay Greenfield <jag@timberline.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres slower than MS ACCESS
Date: Tue, 14 Feb 2006 08:17:08 -0800
Message-ID: <200602141617.k1EGH8iO021425@timberline.ca> (raw)
In-Reply-To: <1139933084.22740.177.camel@state.g2switchworks.com>
Is it possible to configure Postgres to behave like Access - a single user
and use as much of the recourses as required?
Thanks,
Jay.
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Scott Marlowe
Sent: Tuesday, February 14, 2006 8:05 AM
To: Jay Greenfield
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgres slower than MS ACCESS
On Tue, 2006-02-14 at 09:51, Jay Greenfield wrote:
> I am running some simple queries to benchmark Postgres 8.1 against MS
> Access and Postgres is 2 to 3 times slower that Access.
A BUNCH OF STUFF SNIPPED
> Why does Access run so much faster? How can I get Postgres to run as
> fast as Access?
Because Access is not a multi-user database management system designed
to handle anywhere from a couple to several thousand users at the same
time?
PostgreSQL can do this update while still allowing users to access the
data in the database, and can handle updates to the same table at the
same time, as long as they aren't hitting the same rows.
They're two entirely different beasts.
One is good at batch processing moderate amounts of data for one user at
a time. The other is good for real time processing of very large
amounts of data for a fairly large number of users while running at an
acceptable, if slower speed.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jag@timberline.ca
Subject: Re: Postgres slower than MS ACCESS
In-Reply-To: <200602141617.k1EGH8iO021425@timberline.ca>
References: <1139933084.22740.177.camel@state.g2switchworks.com> <200602141617.k1EGH8iO021425@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