| From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: setproctitle_fast() |
| Date: | 2018-07-07 11:57:01 |
| Message-ID: | CAE2gYzy=g2iAhFA3yVQ+_ZgZsiBnGwF2S7BwFX4QOcvZneyeHg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> FreeBSD's setproctitle() is a bit slow because it contains a syscall
> or two, so people often run PostgreSQL with update_process_title set
> to off on that OS. That makes the user experience not quite as nice
> as Linux. As a weekend learn-me-some-kernel-hacking project I fixed
> that and got the patch committed to FreeBSD 12, though I was asked to
> use a new libc entry point _fast(). Here's a patch to teach
> PostgreSQL about that. It doesn't have much effect on small systems,
> but it makes "pgbench -c 40 -j 40 -S -M prepared" do ~10% more
> transactions per second on an AWS m4.10xlarge instance.
I am curious why they asked you to use a new libc entry point. The
function signatures are the same. More people could benefit from
making the existing function faster.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent Kerby | 2018-07-07 12:05:59 | Re: Transition relations: correlating OLD TABLE and NEW TABLE |
| Previous Message | Fabien COELHO | 2018-07-07 08:31:36 | Re: Desirability of client-side expressions in psql? |