Re: Index with all necessary columns - Postgres vs MSSQL

May be I should first try to partition the table by date and see if that
helps.

Thanks,
- Gummi

On Thu, Feb 2, 2012 at 8:30 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:

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