Weird query speed
От | Rigmor Ukuhe |
---|---|
Тема | Weird query speed |
Дата | |
Msg-id | OEEHLFAIJHHMABJPIANIGELICHAA.rigmor.ukuhe@finestmedia.com обсуждение исходный текст |
Ответы |
Re: Weird query speed
|
Список | pgsql-performance |
Almoust identical querys are having very different exec speed (Postgresql 7.2.4). query: select "NP_ID" from a WHERE "NP_ID" > '0' Index Scan using NP_ID_a on a (cost=0.00..13.01 rows=112 width=4) (actual time=16.89..18.11 rows=93 loops=1) Total runtime: 18.32 msec ------------------------------------------------- query: select "NP_ID" from a WHERE "NP_ID" > '1' Index Scan using NP_ID_a on a (cost=0.00..13.01 rows=112 width=4) (actual time=0.08..1.36 rows=93 loops=1) Total runtime: 1.56 msec From where such difference comes? There are about 37K rows and only about 100 of then are not "NP_ID" = 0 For a workaround i use WHERE "NP_ID" >= '1' and if works as speedy as '> 1' Rigmor Ukuhe --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08.01.2004
В списке pgsql-performance по дате отправления: