Skip site navigation (1) Skip section navigation (2)

Re: select slow?

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Jaime Casanova <el_vigia_ec(at)hotmail(dot)com>
Cc: "pgsql-performance (at) postgresql (dot) org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select slow?
Date: 2004-03-30 19:39:21
Message-ID: 20040330203921.A16296@bacon (view raw or flat)
Thread:
Lists: pgsql-performance
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   |
+------------------------------+---------------------------------------------+

In response to

pgsql-performance by date

Next:From: Robert TreatDate: 2004-03-30 20:06:08
Subject: Re: Nested Sets WAS: column size too large, is this a bug?
Previous:From: Jaime CasanovaDate: 2004-03-30 19:25:40
Subject: select slow?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group