| From: | "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> |
|---|---|
| To: | Florian Weimer <fweimer(at)bfk(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Inserting 8MB bytea: just 25% of disk perf used? |
| Date: | 2010-01-14 21:27:19 |
| Message-ID: | 20100114212719.GE2384@comppasch2 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Florian Weimer:
> > Do you have any further idea why 16MB/s seems to be the limit here?
>
> BYTEA deserialization is very slow, and this could be a factor here.
> Have you checked that you are in fact I/O bound?
Could you elaborate that a bit? It sounds interesting but I
do not get what you mean by:
"bytea deserialization": Do you mean from an escaped string
back to real binary data? Does that apply to my case (I use
PGexecParam and have the Format arg set to 1, binary) ?
"I/O bound": What do you mean by that?
> You can speed things up by sending the data in binary, by passing
> approriate parameters to PQexecParams().
Do you mean the Format arg =1 ? If not, what is appropriate
here?
Felix
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fkater@googlemail.com | 2010-01-14 21:28:07 | Re: Inserting 8MB bytea: just 25% of disk perf used? |
| Previous Message | Carlo Stonebanks | 2010-01-14 21:25:00 | New server to improve performance on our large and busy DB - advice? (v2) |