On 2019-03-22 13:40:28 +0100, Francisco Olarte wrote:
> On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
> 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.
> >
Thomas:
On Fri, Mar 22, 2019 at 2:03 PM Thomas Güttler
wrote:
> > I'm not too sure, but I read ( in the code ) you are measuring a
> > nearly not compressible urandom data againtst a highly compressible (
...
> for this case toast-tables/wal is a detail of the implementation.
> This tests does no
On 3/22/19 6:04 AM, Thomas Güttler wrote:
Am 22.03.19 um 13:40 schrieb Francisco Olarte:
Thomas:
On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
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,
i
Am 22.03.19 um 13:40 schrieb Francisco Olarte:
Thomas:
On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
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 th
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
> 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
Thomas:
On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
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
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 wh
