Re: Index with all necessary columns - Postgres vs MSSQL - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Index with all necessary columns - Postgres vs MSSQL
Date
Msg-id CAHyXU0zxn4u7kTQhX9U=xk1Cxy2LtHiKd0a=WcpvuZEviG248w@mail.gmail.com
Whole thread Raw
In response to Index with all necessary columns - Postgres vs MSSQL  (Gudmundur Johannesson <gudmundur.johannesson@gmail.com>)
Responses Re: Index with all necessary columns - Postgres vs MSSQL  (Gudmundur Johannesson <gudmundur.johannesson@gmail.com>)
List pgsql-performance
On Thu, Feb 2, 2012 at 10:41 AM, Gudmundur Johannesson
<gudmundur.johannesson@gmail.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

pgsql-performance by date:

Previous
From: Alessandro Gagliardi
Date:
Subject: Re: From Simple to Complex
Next
From: Jeff Janes
Date:
Subject: Re: *really* bad insert performance on table with unique index