Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7E888633D82
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 16:19:34 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 65538-08
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 20:19:20 +0000 (UTC)
X-Greylist: delayed 00:05:00.036972 by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.156])
	by mail.postgresql.org (Postfix) with ESMTP id 07C64632D2C
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 16:19:22 -0400 (AST)
Received: by fg-out-1718.google.com with SMTP id e21so415600fga.1
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 12:19:21 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=googlemail.com; s=gamma;
	h=domainkey-signature:received:received:received:date:from:to:cc
	:subject:message-id:references:mime-version:content-type
	:content-disposition:in-reply-to:user-agent;
	bh=4dzK450/UMDGA0KCIK4yfJEEri5uyHXmkUyD0hxr0IY=;
	b=we5CdmJjQR6ufiXvOX01s2isL+nLoft/pyKIcjJW/GfuLVYUnjw7vMHuYVyJJFWVl4
	DgDlYNtTvwpJLFc3VFfz3eqDNLQ8wvwwmO7LkhFQYpykBRECcUHiZVqCSNG7Bjjkxikr
	h0ExFuSfvhrI3hJAt4AvzLBenkclIS7GOLyM4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma;
	h=date:from:to:cc:subject:message-id:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=KfjpC084xk1rc0PjEMt5TEEiq0vh1VO5jVwJLpXYq1RyevJkhP/AGmJM6O49rldvrE
	MlCuyuXmW06oqVJbo7qAPh+xBHXUTRJDlB1WoNT9wFiZxrmhsVsf2fFrY8IQ4KCuoLlX
	S4mh8i6HMH+hrXPw1zkL1bYgR7Xep+kTWkZCk=
Received: by 10.86.126.35 with SMTP id y35mr1636784fgc.75.1263500060211;
	Thu, 14 Jan 2010 12:14:20 -0800 (PST)
Received: from googlemail.com (port-87-193-148-114.static.qsc.de
	[87.193.148.114])
	by mx.google.com with ESMTPS id 14sm462110fxm.7.2010.01.14.12.14.18
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 14 Jan 2010 12:14:18 -0800 (PST)
Received: by googlemail.com (nbSMTP-1.00) for uid 1100
	(using TLSv1/SSLv3 with cipher RC4-MD5 (128/128 bits))
	fkater@googlemail.com; Thu, 14 Jan 2010 21:14:18 +0100 (CET)
Date: Thu, 14 Jan 2010 21:14:17 +0100
From: "fkater@googlemail.com" <fkater@googlemail.com>
To: Hannu Krosing <hannu@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Message-ID: <20100114201417.GB2384@comppasch2>
References: <20100114142903.GB2973@comppasch2>
 <1263481236.2110.12.camel@hvost>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <1263481236.2110.12.camel@hvost>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201001/307
X-Sequence-Number: 37187


Thanks a lot for your reply.

Hannu Krosing:

> > 4 Core CPU 3 Ghz, WinXP, 1 TB SATA disk.
> 
> try inserting the same data using 4 parallel connections or even 8
> parallel ones.

Interesting idea -- I forgot to mention though that 2-3
cores will be occupied soon with other tasks.

 Felix