Postgres Pro
Downloads
Home   >   mailing lists

Re: Inserting 8MB bytea: just 25% of disk perf used? - Mailing list pgsql-performance

From fkater@googlemail.com
Subject Re: Inserting 8MB bytea: just 25% of disk perf used?
Date
Msg-id 20100119105526.GC2200@comppasch2
Whole thread Raw
In response to Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
List pgsql-performance
Tree view 
Pierre Frédéric Caillaud:

> I don't remember if you used TOAST compression or not.

I use 'bytea' and SET STORAGE EXTERNAL for this column.
AFAIK this switches off the compression.

pgsql-performance by date:

Previous
From: "fkater@googlemail.com"
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Next
From: Ivan Voras
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?