Re: Index with all necessary columns - Postgres vs MSSQL

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

Предыдущее
От: Alessandro Gagliardi
Дата:
Сообщение: Re: From Simple to Complex
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: *really* bad insert performance on table with unique index