Is that a bug?

From: R D <mrk279(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Is that a bug?
Date: 2000-12-21 08:14:57
Message-ID: 20001221081457.71924.qmail@web10001.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I have some problems with postgresql 7.0.3 running on
Slackware linux 7.1.

I have a table with about 25 milion records:

create table gsc_act(reg_id int2,id int2,ra int4, de
int4,mag int2);

i created 2 indexes:

create index gsc_act_de on gsc_act(de);
create index gsc_act_rd on gsc_act(de,ra);

so every thing was ok with queries:
1. select * from gsc_act where de>=-300000
and de<300000 and ra<=600000 and ra>=0;
2. select * from gsc_act where de>=-300000
and de<300000 and ra<=600000 and ra>=0
and mag<300;

except the second one was too slow and I created third
index:

create index gsc_act_rdm on gsc_act(de,ra,mag);

I executed query 2 and it hang for 5-6 min with
permanent disk activity even Ctrl-C could not stop it.
I killed postmaster and droped the third index. Now
both queries hang the same way. Is there any way to
fix it? This are the most used queries with the
table(only the values are different).
Is this some bug in postgres?
Please help!

Rumen

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Arthur Silve 2000-12-21 09:40:31 Re: Is that a bug?
Previous Message Oliver Elphick 2000-12-20 22:40:03 Re: Re: Restore template1