fkater@xxxxxxxxxxxxxx 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.
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
