Re: [HACKERS] understanding bitmap index benefit

2005-05-19 Thread Oleg Bartunov
On Thu, 19 May 2005, Tom Lane wrote: Oleg Bartunov writes: I tried to see io statistics, but it was weird in 8.0X and in 8.1dev I still don't understand it :) We aren't yet updating the io statistics for bitmap scans properly. There was a thread about this but it petered out without any resolutio

Re: [HACKERS] understanding bitmap index benefit

2005-05-19 Thread Tom Lane
Oleg Bartunov writes: > I tried to see io statistics, but it was weird in 8.0X and in 8.1dev I still > don't understand it :) We aren't yet updating the io statistics for bitmap scans properly. There was a thread about this but it petered out without any resolution about what we should do ...

Re: [HACKERS] understanding bitmap index benefit

2005-05-19 Thread Oleg Bartunov
yOn Thu, 19 May 2005, Oleg Bartunov wrote: Tom, I noticed that along with many improvements in join operations bitmap index speed up execution of first time query. It's known complain about slow full text searching when query runs for the first time. But in CVS version I see very nice behaviour I'd