Postgres Pro
Downloads
Home   >   mailing lists

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

From Ivan Voras
Subject Re: Inserting 8MB bytea: just 25% of disk perf used?
Date
Msg-id hinat9$ahg$1@ger.gmane.org
Whole thread Raw
In response to Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Responses Re: Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: a heavy duty operation on an "unused" table kills my server
Next
From: tom
Date:
Subject: Slow "Select count(*) ..." query on table with 60 Mio. rows