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 51E2D9DCA41 for ; Tue, 14 Feb 2006 17:25:34 -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 70059-02-2 for ; Tue, 14 Feb 2006 17:25:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from timberline.ca (unknown [66.244.194.163]) by postgresql.org (Postfix) with ESMTP id BA6F29DCA47 for ; Tue, 14 Feb 2006 17:25:31 -0400 (AST) Received: from tfic21 ([172.16.10.21]) by timberline.ca (8.12.9/8.12.9) with ESMTP id k1ELPWiO003835; Tue, 14 Feb 2006 13:25:32 -0800 (PST) Message-Id: <200602142125.k1ELPWiO003835@timberline.ca> From: "Jay Greenfield" To: "'Tom Lane'" Cc: "'Stephen Frost'" , Subject: Re: Postgres slower than MS ACCESS Date: Tue, 14 Feb 2006 13:25:32 -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: <22608.1139950952@sss.pgh.pa.us> Thread-Index: AcYxqf2QLZnOGhtSQveGzMVvFPv7RgAAwWeA 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.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200602/178 X-Sequence-Number: 17164 > Hmm, the large number of columns might have something to do with it ... > what datatypes are the columns? All sorts, but mostly float4 and varchar(2 to 10) Jay -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, February 14, 2006 1:03 PM To: Jay Greenfield Cc: 'Stephen Frost'; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgres slower than MS ACCESS "Jay Greenfield" writes: > The table is 1.2 million rows X 246 columns. The only index is the primary > key. I will try to remove that index to see if that improves performance at > all. Hmm, the large number of columns might have something to do with it ... what datatypes are the columns? regards, tom lane