| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
| Cc: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Script which shows performance of ByteA: ascii vs binary |
| Date: | 2019-03-22 12:48:32 |
| Message-ID: | 20190322124832.GA5616@aart.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 22, 2019 at 01:40:28PM +0100, Francisco Olarte wrote:
> Thomas:
>
> On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
> <guettliml(at)thomas-guettler(dot)de> wrote:
> > Thank you for asking several times for a benchmark.
> > I wrote it now and it is visible: inserting random bytes into bytea is much slower,
> > if you use the psycopg2 defaults.
> > Here is the chart:
> > https://github.com/guettli/misc/blob/master/bench-bytea-inserts-postrgres.png
> > And here is the script which creates the chart:
> > https://github.com/guettli/misc/blob/master/bench-bytea-inserts-postrgres.py
>
> I'm not too sure, but I read ( in the code ) you are measuring a
> nearly not compressible urandom data againtst a highly compressible (
> 'x'*i ) data,
> are you sure the difference is not due to data being compressed and
> generating much less disk usage in toast-tables/wal?
>
> Francisco Olarte.
>
+1
Regards,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Güttler | 2019-03-22 13:04:15 | Re: Script which shows performance of ByteA: ascii vs binary |
| Previous Message | Francisco Olarte | 2019-03-22 12:40:28 | Re: Script which shows performance of ByteA: ascii vs binary |
