Re: Is that a bug?

Hmm, does a plain select * from gsc_act work?
Also, what does explain show for the queries?

Stephan Szabo
sszabo@bigpanda.com

On Thu, 21 Dec 2000, R D wrote:

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