Date: Wed, 15 Nov 2017 13:20:53 +0300
From: Aleksander Alekseev <a.alekseev@postgrespro.ru>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Oleg Bartunov <obartunov@gmail.com>,
	Anthony Bykov <a.bykov@postgrespro.ru>,
	Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Transform for pl/perl
Message-ID: <20171115102052.GA10364@e733.localdomain>
References: <20171024140129.6bd01f68@anthony-24-g082ur>
 <20171024152709.641251ae@anthony-24-g082ur>
 <CAFj8pRBon6AOpRqFHx_fbJEzstRC3_kyEcUf77bmpUve82CCPA@mail.gmail.com>
 <20171114113455.13ee84d7@anthony-24-g082ur>
 <CAF4Au4wUZDKUheAQ0_5DEEPwc1cwEqg1PgvS1M+xBrm+UvafPA@mail.gmail.com>
 <CAFj8pRDm4ZV1goDnMmPi_M_a5MyTShS1GQwFDHAtBrVMg17aCA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="DocE+STaALJfprDB"
Content-Disposition: inline
In-Reply-To: 
 <CAFj8pRDm4ZV1goDnMmPi_M_a5MyTShS1GQwFDHAtBrVMg17aCA@mail.gmail.com>
User-Agent: Mutt/1.9.1 (2017-09-22)
Precedence: bulk


--DocE+STaALJfprDB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hello, hackers.

> > I'm curious, how much benefit we could get from this ? There are several
> > publicly available json datasets, which can be used to measure performa=
nce
> > gaining. I have bookmarks and review datasets available from
> > http://www.sai.msu.su/~megera/postgres/files/, look at js.dump.gz and
> > jr.dump.gz
> >
>=20
> I don't expect significant performance effect - it remove some
> transformations - perl object -> json | json -> jsonb - but on modern cpu
> these transformations should be fast. For me - main benefit is user comfo=
rt
> - it does direct transformation from perl object -> jsonb

I completely agree that currently the main benefit of this feature is
user comfort. So correctness is the priority. When we make sure that the
implementation is correct we can start worry about the performance.
Probably in a separate patch.

Thanks for the datasets though!

--=20
Best regards,
Aleksander Alekseev

--DocE+STaALJfprDB
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCAAdFiEECAokn0QZCoIHW4GpEEnCBLXCDtYFAloMFQIACgkQEEnCBLXC
Dtb1Cw//bczuHSNzjJs50EGpeLk94vRQYYNCYFdI6nLEIcvusNUAURYp/h7ml4/M
yM6nERmmxOvQnAPJa6NEzTAybAUld5DKOuhihxIyQ3YjG/ZhuqyBCt7tTS5YWCP/
UG/9Ko4vtkr22xcCy1H/TW7DqL3xh0Xnm5warLL1Qx7q99P8+iLUX5QDN2n1DQX4
II7GrYIRski8rprlFj4yurJ8M/VigoAzyFG+ae2B2TKs1Uwno/ZZHdPhIPeLEtKQ
S6eCuJ703r0GS+5JEftQgdzKjcbR2KPvW5w5nxYELNLGRjerNZ1dTSSt1hLHw//w
IsqRCF2G/Dpbh2eplc4gmCmmEuyQfeiqlgXHSTaBWACcx9k6Bwi1mfQ1glYuadb6
DFyNSeStcb/Afm+RflPXA6nePaVdFSWauwYE9rJJ5q8mqGnrCTRkx3snmUi5/s2H
6IKl/1T/SMwzUD8bPfmgjqpl+qRj60CK/virKhplOgzqTpoQlBDMqu9Xl+kQsvs5
tR471L8b+R0KHRVSCgTOCU9E34WFmJOFHThJlADGH9GEcAej84Ng8XlswLUmdQhC
Qrpf9LVn6Gw4LFdN16IuenZM1qTLDfOagz5CSW8wb46iC/XdeLfOmospZ4ZDEk9b
yByrAVwulIqEC64pZ2r42F3VTKV+KV758O3d2f5sl7FDKoK617A=
=GwAM
-----END PGP SIGNATURE-----

--DocE+STaALJfprDB--