Re: Progress on fast path sorting, btree index creation time

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Progress on fast path sorting, btree index creation time
Дата
Msg-id 20120208155902.GE24440@momjian.us
обсуждение исходный текст
Ответ на Re: Progress on fast path sorting, btree index creation time  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Progress on fast path sorting, btree index creation time  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Progress on fast path sorting, btree index creation time  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Feb 08, 2012 at 10:17:36AM -0500, Robert Haas wrote:
> On Wed, Feb 8, 2012 at 9:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > IMO this patch is already well past the point of diminishing returns in
> > value-per-byte-added.  I'd like to see it trimmed back to provide a fast
> > path for just single-column int4/int8/float4/float8 sorts.  The other
> > cases aren't going to offer enough of a win to justify the code space.
> 
> I'm curious about how much we're gaining from the single-column
> specializations vs. the type-specific specializations.  I think I'm
> going to go try to characterize that.

Yes, please.  That would be a big help.   Is there no optimization for
strings?  I assume they are sorted a lot.  

We can alway add more data types later.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Progress on fast path sorting, btree index creation time
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pgstat documentation tables