Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns
От
Andres Freund
Тема
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns
Дата
Msg-id
20170929225458.ahlwn4uljc5sttcz@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
[HACKERS] SendRowDescriptionMessage() is slow for queries with a lot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with a lot of columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with a lot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with a lot of columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Thom Brown <thom@linux.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Thom Brown <thom@linux.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Andres Freund <andres@anarazel.de>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] SendRowDescriptionMessage() is slow for queries with alot of columns Mithun Cy <mithun.cy@enterprisedb.com>
On 2017-09-29 17:56:10 -0400, Tom Lane wrote:
> Andres Freund writes:
> > Does anybody have an opinion on whether we'll want to convert examples
> > like testlibpq3.c (included in libpq.sgml) too? I'm inclined not to,
> > because currently using pg_bswap.h requires c.h presence (just for a few
> > typedefs and configure data). There's also not really a pressing need.
>
> We certainly mustn't encourage libpq users to start depending on c.h,
> so let's leave that alone.
Here's two patches:
0001: Previously submitted changes to pg_bswap.h, addressing concerns
like the renaming
0002: Move over most users of ntoh[sl]/hton[sl] over to pg_bswap.h.
Note that the latter patch includes replacing open-coded byte swapping
of 64bit integers (using two 32 bit swaps) with a single 64bit
swap. I've also removed pg_recvint64 - it's now a single pg_ntoh64 - as
it's name strikes me as misleading.
Where it looked applicable I have removed netinet/in.h and arpa/inet.h
usage, which previously provided the relevant functionality. It's
perfectly possible that I missed other reasons for including those,
the buildfarm will tell.
Greetings,
Andres Freund
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Martin Marques
Дата: