From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Peter Geoghegan <pg(at)heroku(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Should TIDs be typbyval = FLOAT8PASSBYVAL to speed up CREATE INDEX CONCURRENTLY? |
Date: | 2015-12-16 20:28:34 |
Message-ID: | CA+TgmobL-9Ov1jPjN7ixbqpS23cjLqj=zr5ffV0Gm2b+mzwt6w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Nov 17, 2015 at 6:50 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> On Tue, Nov 17, 2015 at 12:53 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> Short and sweet! Looks good.
>
> Thanks.
>
>> I would be inclined to add more comments to explain it, these things have a
>> habit of being forgotten.
>
> I'm not sure what additional detail I can add.
>
> I seem to be able to produce these sorting patches at a much greater
> rate than they can be committed, in part because Robert is the only
> one that ever reviews them, and he is only one person.
I object to that vicious slander. I am at least three people, if not more!
Meanwhile, I did some simple benchmarking on your latest patch on my
MacBook Pro. I did pgbench -i -s 100 and then tried:
create index x on pgbench_accounts (aid);
create index concurrently x on pgbench_accounts (aid);
The first took about 6.9 seconds. The second took about 11.3 seconds
patched versus 14.6 seconds unpatched. That's certainly a healthy
improvement.
I then rebuilt with --disable-float8-byval, because I was worried that
case might be harmed by this change. It turns out we win in that case
too, just not by as much. The time for the first case doesn't change
much, and neither does the unpatched time. The patched time is about
12.9 seconds.
I have also reviewed the code, and it looks OK to me, so committed.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-12-16 20:44:16 | Re: fix for readline terminal size problems when window is resized with open pager |
Previous Message | Tom Lane | 2015-12-16 20:12:44 | Re: fix for readline terminal size problems when window is resized with open pager |