X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DADBED1E294 for ; Wed, 31 Mar 2004 17:27:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94132-10 for ; Wed, 31 Mar 2004 13:27:04 -0400 (AST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id 27EF3D1E172 for ; Wed, 31 Mar 2004 13:27:04 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 1B8jUV-0007xz-0X for pgsql-performance@postgresql.org; Wed, 31 Mar 2004 18:27:03 +0100 Date: Wed, 31 Mar 2004 18:27:01 +0100 From: Paul Thomas To: "pgsql-performance @ postgresql . org" Subject: Re: select slow? Message-ID: <20040331182701.A17746@bacon> References: <5090.1080747621@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <5090.1080747621@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Wed, Mar 31, 2004 at 16:40:21 +0100 X-Mailer: Balsa 1.2.3 Lines: 29 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/442 X-Sequence-Number: 6298 On 31/03/2004 16:40 Tom Lane wrote: > "Jaime Casanova" writes: > > There are no indexes yet, and the table is just 6 rows long so even if > > indexes exists the planner will do a seq scan. that's my whole point > 63m for > > seq scan in 6 rows table is too much. > > That was 63 milliseconds, according to your original post, which seems > perfectly reasonable to me seeing that it's not a super-duper server. > > The problem sounds to be either on the client side or somewhere in your > network. I don't know anything about VB, but you might want to look > through the client-side operations to see what could be eating up the 13 > seconds. Given that the client and server are on different machines, I'm wondering the bulk of the 13 seconds is due a network mis-configuration or a very slow DNS server... -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+