Re: Inserting 8MB bytea: just 25% of disk perf used?

fkater@googlemail.com wrote:
> Hello together,
>
> I need to increase the write performance when inserting
> bytea of 8MB. I am using 8.2.4 on windows with libpq.

>
> This takes about 50s, so, 800MB/50s = 16MB/s.
>
> However the harddisk (sata) could write 43 MB/s in the worst
> case! Why is write performance limited to 16 MB/s?
>
>
> Do you have any further idea why 16MB/s seems to be the
> limit here?

Are you doing it locally or over a network? If you are accessing the
server over a network then it could be the location of the bottleneck.