Hi,
if you want to do dirty counts or sums or any aggreate stuff, you will always
have to visit the table. For many applications nobody cares about 0,01%
inaccuracy.
If you could keep the data that has to be aggregated in the index you could
approximate values really fast.
But because "Read u
I was wondering if the index-only-scan will be available in 9.2? This is not
having to visit the real data to answer a query, if all the information is
available in the index. I think this will be a mayor step in overtaking the big
O in the g-spot.
There seams to already be some patch for this
