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 492D4D1B493 for ; Tue, 30 Mar 2004 19:39:32 +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 56472-04 for ; Tue, 30 Mar 2004 15:39:30 -0400 (AST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id A2311D1E0F0 for ; Tue, 30 Mar 2004 15:39:25 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1B8P53-0005NW-0Z; Tue, 30 Mar 2004 20:39:25 +0100 Date: Tue, 30 Mar 2004 20:39:21 +0100 From: Paul Thomas To: Jaime Casanova Cc: "pgsql-performance @ postgresql . org" Subject: Re: select slow? Message-ID: <20040330203921.A16296@bacon> References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: ; from el_vigia_ec@hotmail.com on Tue, Mar 30, 2004 at 20:25:40 +0100 X-Mailer: Balsa 1.2.3 Lines: 40 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/425 X-Sequence-Number: 6281 On 30/03/2004 20:25 Jaime Casanova wrote: > hi all, > > > i have an amd athlon with 256 ram (i know, this is not a *real* server > but my tables are small) > > i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the psqlodbc. > > when i do a select in took long to execute, here is an example > > > table icc_m_banco > > CREATE TABLE ICC_M_BANCO ( > CodBanco SMALLINT NOT NULL, > Descripcion CHARACTER VARYING(60) NOT NULL, > RefContable NUMERIC, > Estado CHAR(1) NOT NULL, > FecRegistro DATE NOT NULL, > CONSTRAINT EstadoBanco CHECK ((Estado = 'A') or (Estado = 'I')), > PRIMARY KEY(CodBanco) > ); > > > select * from icc_m_banco where codbanco = 1; select * from icc_m_banco where codbanco = 1::int2; -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+