Re: [PERFORM] performance index scan vs bitmap-seq scan.

2007-12-20 Thread Scott Marlowe
On Dec 20, 2007 4:06 PM, S Golly <[EMAIL PROTECTED]> wrote: > The server is running 8.2.5 FreeBSD 6.1 with 3 GB of RAM. > I have a table with over 100M rows. I have a unique index (primary key) on > column name called aid. > The select count(aid) .. does a Bitmap heap scan when the right side > con

[PERFORM] performance index scan vs bitmap-seq scan.

2007-12-20 Thread S Golly
The server is running 8.2.5 FreeBSD 6.1 with 3 GB of RAM. I have a table with over 100M rows. I have a unique index (primary key) on column name called aid. The select count(aid) .. does a Bitmap heap scan when the right side condition is above 100,000,000 (if i take one zero off it does a pure ind