""John Top-k apad"" <[EMAIL PROTECTED]> wrote
>
> from pg_stast_get_blocks_fetched i can see that both queries need almost
the
> same number of disk fetches which is quite reasonable ( the index is
> unclustered).
>
> But as you can see there is a great variation between query
> runtimes.Cansomeon
Hi,I have the following quering plans:"Seq Scan on ind_uni_100 (cost=0.00..27242.00 rows=100 width=104) (actual time=0.272..2444.667 rows=100 loops=1)""Total runtime: 4229.449 ms"
and"Bitmap Heap Scan on ind_uni_100 (cost=314.00..18181.00 rows=5 width=104) (actual time=74.106..585.368
