Re: Efficient output for integer types

From: David Fetter <david(at)fetter(dot)org>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Efficient output for integer types
Date: 2019-09-20 21:18:13
Message-ID: 20190920211813.GG31596@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 20, 2019 at 11:09:16PM +0200, David Fetter wrote:
> On Fri, Sep 20, 2019 at 09:14:51PM +0200, David Fetter wrote:
> > On Wed, Sep 18, 2019 at 04:27:46PM +0900, Kyotaro Horiguchi wrote:
> > > Hello.
> > >
> > > At Wed, 18 Sep 2019 05:42:01 +0200, David Fetter <david(at)fetter(dot)org> wrote in <20190918034201(dot)GX31596(at)fetter(dot)org>
> > > > On Tue, Sep 17, 2019 at 09:01:57AM +0200, David Fetter wrote:
> > > > > On Tue, Sep 17, 2019 at 08:55:05AM +0200, David Fetter wrote:
> > > > > > On Sun, Sep 15, 2019 at 09:18:49AM +0200, David Fetter wrote:
> > > > > > > Folks,
> > > > > > >
> > > > > > > Please find attached a couple of patches intended to $subject.
> > > > > > >
> > > > > > > This patch set cut the time to copy ten million rows of randomly sized
> > > > > > > int8s (10 of them) by about a third, so at least for that case, it's
> > > > > > > pretty decent.
> > > > > >
> > > > > > Added int4 output, removed the sprintf stuff, as it didn't seem to
> > > > > > help in any cases I was testing.
> > > > >
> > > > > Found a couple of "whiles" that should have been "ifs."
> > > >
> > > > Factored out some inefficient functions and made the guts use the more
> > > > efficient function.
> > >
> > > I'm not sure this is on the KISS principle, but looked it and
> > > have several random comments.
> > >
> > > +numutils.o: CFLAGS += $(PERMIT_DECLARATION_AFTER_STATEMENT)
>
> Oops. Missed a few.

D'oh! Wrong patch.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment Content-Type Size
v9-0001-Make-int4-and-int8-operations-more-efficent.patch text/x-diff 13.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Castillo, Steven (Agile) 2019-09-20 21:21:59 Hi guys, HELP please
Previous Message David Fetter 2019-09-20 21:09:16 Re: Efficient output for integer types