Yes that was the problem! Thank you very much
On Thu, 13 Jul 2006, Tom Lane wrote:
[EMAIL PROTECTED] writes:
... is quite reasonable.The table has 1.000.000 rows (17.242 pages). From
pg_stat_get_blocks_fetched I can see that there were 102 page requests for
table. So all things seem to work g
[EMAIL PROTECTED] writes:
> ... is quite reasonable.The table has 1.000.000 rows (17.242 pages). From
> pg_stat_get_blocks_fetched I can see that there were 102 page requests for
> table. So all things seem to work great here!
> But if I multiply the size of the table ten-times (10.000.000 rows -
Hi,
If I run the query
explain analyze select * from ind_uni_100 where a=1 and b=1 and c=1
I get the following plan:
Bitmap Heap Scan on ind_uni_100 (cost=942.50..1411.12 rows=125 width=104)
(actual time=72.556..72.934 rows=116 loops=1)
Recheck Cond: ((c = 1) AND (a = 1) AND (b = 1))
-> Bi
