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
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
