Another "why am I not using the indicies?"

From: "Clinton James" <cjames(at)callone(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Another "why am I not using the indicies?"
Date: 2001-05-04 13:49:55
Message-ID: LDEHLKIELLEDPDLPHDILAEBJCHAA.cjames@callone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is all the information about the system and the steps I took. If you
can tell me or point me in the right direction I would appreciate it. There
are 624306 records in this table, so it only takes a few seconds, but this
is going to grow to 5M rows/month when this works properly.

Clinton James

#select version();
version
----------------------------------------------------------------------
PostgreSQL 7.1rc4 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

#CREATE TABLE ld (
billmonth CHAR(4),
cust_num CHAR(8),
location CHAR(4),
date TIMESTAMP,
orignum CHAR(10),
destnum CHAR(13),
destcity CHAR(10),
deststate CHAR(2),
duration NUMERIC(8,1),
callcode CHAR(9),
cost NUMERIC(10,4)
);

#copy ld from '/tmp/ld0104.txt';

#create index ld_custnum_idx ON ld(cust_num);
#create index ld_orignum_idx ON ld(orignum);

#vacuum analyze;

# explain select * from ld where cust_num = '10102899';
NOTICE: QUERY PLAN:

Seq Scan on ld (cost=0.00..20810.83 rows=8989 width=128)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2001-05-04 13:54:51 Re: cast bit to boolean?
Previous Message Justin Clift 2001-05-04 13:38:04 Re: Ideal hardware configuration for pgsql