From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | R D <mrk279(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Is that a bug? |
Date: | 2000-12-21 16:54:06 |
Message-ID: | Pine.BSF.4.21.0012210853120.86012-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hmm, does a plain select * from gsc_act work?
Also, what does explain show for the queries?
Stephan Szabo
sszabo(at)bigpanda(dot)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!
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Husmann | 2000-12-22 07:28:51 | IPC Problem |
Previous Message | R D | 2000-12-21 15:29:52 | Disk full and table empty |