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

From Gudmundur Johannesson
Subject Re: Index with all necessary columns - Postgres vs MSSQL
Date
Msg-id CAHNvtn9hj0vyAHkzokTdCMWQ7KRSvKTuE-4bMke_pHU5KawkVg@mail.gmail.com
Whole thread Raw
In response to Re: Index with all necessary columns - Postgres vs MSSQL  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
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@gmail.com> wrote:
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: Gudmundur Johannesson
Date:
Subject: Re: Index with all necessary columns - Postgres vs MSSQL
Next
From: "Marc Mamin"
Date:
Subject: text search: tablescan cost for a tsvector