Re: Index with all necessary columns - Postgres vs MSSQL

Поиск
Список
Период
Сортировка
От Gudmundur Johannesson
Тема Re: Index with all necessary columns - Postgres vs MSSQL
Дата
Msg-id CAHNvtn9hj0vyAHkzokTdCMWQ7KRSvKTuE-4bMke_pHU5KawkVg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index with all necessary columns - Postgres vs MSSQL  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Gudmundur Johannesson
Дата:
Сообщение: Re: Index with all necessary columns - Postgres vs MSSQL
Следующее
От: "Marc Mamin"
Дата:
Сообщение: text search: tablescan cost for a tsvector