No, plain select also does not work.
--- Stephan Szabo <sszabo@megazone23.bigpanda.com>
wrote:
>
> 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!
>
>
> .
> me bug in postgres?
> > Please help!
>
>
> .
>
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/