Is that a bug?
От | R D |
---|---|
Тема | Is that a bug? |
Дата | |
Msg-id | 20001221081457.71924.qmail@web10001.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: Is that a bug?
Re: Is that a bug? |
Список | 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/
В списке pgsql-admin по дате отправления: