pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jaime Casanova <el_vigia_ec@hotmail.com>
To: pgsql-performance@postgresql.org
Subject: select slow?
Date: Tue, 30 Mar 2004 19:25:40 +0000
Message-ID: <BAY8-F81VY60mJWEsBk00017a0d@hotmail.com> (raw)

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;

it tooks 13s from it's send until it's executed.



explain analyze give me this result:

explain analyze
select * from icc_m_banco where codbanco = 1;


Seq Scan on icc_m_banco  (cost=0.00..1.06 rows=6 width=41) (actual 
time=7.94..7.96 rows=4 loops=1)
Total runtime: 63.37 msec
(2 rows)


so i think its not a database problem (at least it's not all the problem),
though it seems to me it is taking a lot of time executing this.


am i right? any suggestions?

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail




view thread (6+ messages)  latest in thread

Message-ID: <BAY8-F81VY60mJWEsBk00017a0d@hotmail.com>
Permalink:  ../BAY8-F81VY60mJWEsBk00017a0d@hotmail.com/
Also on:    postgresql.org/message-id/BAY8-F81VY60mJWEsBk00017a0d@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: el_vigia_ec@hotmail.com
  Subject: Re: select slow?
  In-Reply-To: <BAY8-F81VY60mJWEsBk00017a0d@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox