X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D081D9DC881 for ; Tue, 14 Feb 2006 12:17:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59463-02 for ; Tue, 14 Feb 2006 12:17:12 -0400 (AST) X-Greylist: delayed 00:25:42.506916 by SQLgrey- Received: from timberline.ca (unknown [66.244.194.163]) by postgresql.org (Postfix) with ESMTP id 9DF2C9DC83F for ; Tue, 14 Feb 2006 12:17:09 -0400 (AST) Received: from tfic21 ([172.16.10.21]) by timberline.ca (8.12.9/8.12.9) with ESMTP id k1EGH8iO021425 for ; Tue, 14 Feb 2006 08:17:09 -0800 (PST) Message-Id: <200602141617.k1EGH8iO021425@timberline.ca> From: "Jay Greenfield" To: Subject: Re: Postgres slower than MS ACCESS Date: Tue, 14 Feb 2006 08:17:08 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <1139933084.22740.177.camel@state.g2switchworks.com> Thread-Index: AcYxgHEdMx884UH3RvijaSItLyJrBAAAQP/Q X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/162 X-Sequence-Number: 17148 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