From: Aleksander Alekseev <a.alekseev@postgrespro.ru>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Oleg Bartunov <obartunov@gmail.com>
Cc: Anthony Bykov <a.bykov@postgrespro.ru>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Transform for pl/perl
Date: Wed, 15 Nov 2017 13:20:53 +0300
Message-ID: <20171115102052.GA10364@e733.localdomain> (raw)
In-Reply-To: <CAFj8pRDm4ZV1goDnMmPi_M_a5MyTShS1GQwFDHAtBrVMg17aCA@mail.gmail.com>
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>
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 performance
> > 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
> >
>
> 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 comfort
> - 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!
--
Best regards,
Aleksander Alekseev
Attachments:
[application/pgp-signature] signature.asc (832B, ../20171115102052.GA10364@e733.localdomain/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: a.alekseev@postgrespro.ru, pavel.stehule@gmail.com, obartunov@gmail.com, a.bykov@postgrespro.ru
Subject: Re: [HACKERS] Transform for pl/perl
In-Reply-To: <20171115102052.GA10364@e733.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox