Re: Efficient output for integer types

Поиск
Список
Период
Сортировка
Искать
От
Tomas Vondra
Тема
Re: Efficient output for integer types
Дата
Msg-id
20200111133159.ppxnocexkdduo4m6@development
Ответ на
Список
Дерево обсуждения
Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Efficient output for integer types Tels <nospam-pg-abuse@bloodgate.com>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Re: Efficient output for integer types Andrey Borodin <x4mmm@yandex-team.ru>
Re: Efficient output for integer types David Fetter <david@fetter.org>
Hi,

Any plans regarding committing this patch? I see the thread is silent
since September 24, when the last patch version was posted. The patch is
already marked as RFC since December, when David changed the status. I
don't have any opinion whether the patch is RFC or not (it might well
be), but IMHO it should have been mentioned in this thread.

I did a quick test to see how much more efficient this is, and for a
table with 10 bigint columns and 5M random rows the COPY to /dev/null
went from 3000 ms to ~2700 ms. That's not the 30% speedup mentioned by
David in the first message, but 10% is still pretty nice.

Of course, for real-world use cases the speedup will be lower because of
using other data types too, I/O etc. But it's still nice.

So, is anyone opposed to pushing this? If not, who'll to do that?  I see
Andrew Gierth was involved in the discussions on IRC and it's related to
the Ryu patch, so maybe he want's to take care of this. Andrew?


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 


В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата:
От: 曾文旌(义从)
Дата:
FAQ