From: Florian Weimer <fweimer@bfk.de>
To: fkater\@googlemail.com <fkater@googlemail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: Fri, 15 Jan 2010 08:02:49 +0000
Message-ID: <82hbqnkd7a.fsf@mid.bfk.de> (raw)
In-Reply-To: <20100114212719.GE2384@comppasch2>
References: <20100114142903.GB2973@comppasch2>
<82aawgoh09.fsf@mid.bfk.de>
<20100114212719.GE2384@comppasch2>
> 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?
Yes, that is what I meant.
> Does that apply to my case (I use PGexecParam and have the Format
> arg set to 1, binary) ?
Yes, this was my suggestion. There is probably some other issue,
then.
> "I/O bound": What do you mean by that?
You should check (presumably using the Windows performance monitoring
tools, but I'm not familiar with Windows) if the PostgreSQL process is
indeed waiting on disk I/O.
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fweimer@bfk.de, fkater@googlemail.com
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
In-Reply-To: <82hbqnkd7a.fsf@mid.bfk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox