> > It certainly makes quite a difference as I measure it: > > doing select(1) from a 181000 page table (completely uncached) on my PIII: > > 8.0 : 32 s > 8.1 : 25 s > > Note that the 'fastcount()' function takes 21 s in both cases - so all > the improvement seems to be from the count overhead reduction. Are you running windows? There is a big performance improvement in count(*) on pg 8.0->8.1 on win32 that is not relevant to this debate... Merlin
