Re: Fastest memmove in C - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Fastest memmove in C
Date
Msg-id 20160706211501.GA648573@alvherre.pgsql
Whole thread Raw
In response to Re: Fastest memmove in C  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
Responses Re: Fastest memmove in C  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
List pgsql-general
FarjadFarid(ChkNet) wrote:

> Excellent research and could be well worth checking out. As it could
> improve the performance of postgresql engine.

0) We certainly do a lot of memory copying.

1) this work is under the "Code Project Open License" which doesn't look
compatible with our Postgres license on first blush.  Maybe T Herselman
would agree to share under the Postgres licence, which would make things
easier.

2) from the description, the code is probably tailored to specific
compilers.  Even if it's faster now in some mainstream compilers, it
won't be in yesterday or tomorrow's ones.  Also, there are probably
going to be variations depending on CPU features.

3) How much faster does Postgres get when you replace memcpy/memmove
with these Apex versions?  If the percentage to be gained is small, then
there's probably no point in spending a lot of effort into providing
platform-specific implementations of these things anyway.

If you have enough interest in this topic, you could try using these
Apex versions in Postgres and measuring an improvement, to get a
discussion going.

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


pgsql-general by date:

Previous
From: arnaud gaboury
Date:
Subject: Re: Broken after upgrade
Next
From: Lucas Possamai
Date:
Subject: Monitorando WAL Files - PostgreSQL 9.2