Re: Index with all necessary columns - Postgres vs MSSQL

On Thu, Feb 2, 2012 at 10:41 AM, Gudmundur Johannesson
<gudmundur(dot)johannesson(at)gmail(dot)com> wrote:
> Do you think I should try using the latest build of the source for 9.2 since
> index-only-scan is "ready" according to
> http://www.depesz.com/index.php/2011/10/08/waiting-for-9-2-index-only-scans/
> ?

hm, interesting.

You are simply welcome to try that and we would definitely like to see
your results. I looked around and didn't see any binaries for the
development snapshots for windows to test. That means you have to
compile postgres in order to test 9.2 at this point in time. Testing
and feedback of index only scan feature would be very much
appreciated.

Generally speaking, postgresql source tree is very high quality --
stuff should mostly work. The biggest annoyance is that you get lots
of catalog version bumps when pulling new versions of the sources
forcing a dump/reload.

merlin