Re: [PERFORM] select slow?

[Paul Thomas]

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   |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match