X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 24FF3DA254
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 16 Oct 2005 18:12:45 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 60028-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 16 Oct 2005 21:12:41 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by svr1.postgresql.org (Postfix) with ESMTP id CB237D7057
	for <pgsql-performance@postgresql.org>;
	Sun, 16 Oct 2005 18:12:42 -0300 (ADT)
Received: from p548F1258.dip0.t-ipconnect.de [84.143.18.88]
	(helo=pse.dyndns.org)
	by mrelayeu.kundenserver.de with ESMTP (Nemesis),
	id 0ML25U-1ERFo32zCj-0000Og; Sun, 16 Oct 2005 23:12:35 +0200
Received: from p548f1258.dip0.t-ipconnect.de ([84.143.18.88]
	helo=[192.168.0.101])
	by pse.dyndns.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44)
	id 1ERFo2-0007lU-7w; Sun, 16 Oct 2005 23:12:34 +0200
Message-ID: <4352C113.80104@pse-consulting.de>
Date: Sun, 16 Oct 2005 23:07:31 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: NSO <nso@fmf.vtu.lt>
Cc: Mark Kirkwood <markir@paradise.net.nz>,
	pgsql-performance@postgresql.org
Subject: Re: Bytea poor performance
References: <17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt>
	<29778.1129391647@sss.pgh.pa.us>
	<18133.81.7.89.65.1129392990.squirrel@fmf.vtu.lt>
	<4351DCB6.3040307@paradise.net.nz>
	<23627.81.7.89.65.1129460506.squirrel@fmf.vtu.lt>
In-Reply-To: <23627.81.7.89.65.1129460506.squirrel@fmf.vtu.lt>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:0ce7ee5c3478b8d72edd8e05ccd40b70
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.163 required=5 tests=[AWL=0.113,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/248
X-Sequence-Number: 15016

NSO wrote:

>Hello,
>
> No it is not web app, I tested on simple delphi app and with PGAdmin
>III.. same results.. Query from PGAdmin takes up to 30seconds...
>  
>
Displaying the data can take a long time on several platforms for 
pgAdmin; complex controls tend to be dead slow on larger data sets. 
We're waiting for a better wxWidgets solution, I doubt delphi is better...

Regards,
Andreas