X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1A4DBD1B8A5 for ; Thu, 4 Sep 2003 00:54:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 64562-09 for ; Wed, 3 Sep 2003 21:54:47 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 51FD3D1B89D for ; Wed, 3 Sep 2003 21:54:44 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h840sgDf062430 for ; Thu, 4 Sep 2003 00:54:42 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h840Tos3057427 for pgsql-performance@postgresql.org; Thu, 4 Sep 2003 00:29:50 GMT From: "Relaxin" X-Newsgroups: comp.databases.postgresql.performance Subject: SELECT's take a long time compared to other DBMS Date: Wed, 3 Sep 2003 17:28:26 -0700 Organization: Hub.Org Networking Services Lines: 25 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/37 X-Sequence-Number: 3403 I have a table with 102,384 records in it, each record is 934 bytes. Using the follow select statement: SELECT * from PG Info: version 7.3.4 under cygwin on Windows 2000 ODBC: version 7.3.100 Machine: 500 Mhz/ 512MB RAM / IDE HDD Under PG: Data is returned in 26 secs!! Under SQL Server: Data is returned in 5 secs. Under SQLBase: Data is returned in 6 secs. Under SAPDB: Data is returned in 7 secs. This is the ONLY table in the database and only 1 user. And yes I did a vacuum. Is this normal behavior for PG? Thanks