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 21A23DA735 for ; Mon, 17 Oct 2005 05:36:19 -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 94557-10 for ; Mon, 17 Oct 2005 08:36:12 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.183]) by svr1.postgresql.org (Postfix) with ESMTP id 1B874D9EF7 for ; Mon, 17 Oct 2005 05:36:12 -0300 (ADT) Received: from p548F1E2F.dip0.t-ipconnect.de [84.143.30.47] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de with ESMTP (Nemesis), id 0ML2ov-1ERQTd0srO-0000j8; Mon, 17 Oct 2005 10:36:13 +0200 Received: from p548f2989.dip0.t-ipconnect.de ([84.143.41.137] helo=[10.10.11.120]) by pse.dyndns.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1ERQTb-0007u3-FM; Mon, 17 Oct 2005 10:36:11 +0200 Message-ID: <43536167.1010305@pse-consulting.de> Date: Mon, 17 Oct 2005 10:31:35 +0200 From: Andreas Pflug User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: NSO Cc: 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> <4352C113.80104@pse-consulting.de> <3311.85.206.197.88.1129500120.squirrel@fmf.vtu.lt> In-Reply-To: <3311.85.206.197.88.1129500120.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=1.058 required=5 tests=[AWL=-0.784, FORGED_RCVD_HELO=0.05, RCVD_IN_NJABL_DUL=1.655, RCVD_IN_SORBS_DUL=0.137] X-Spam-Level: * X-Archive-Number: 200510/251 X-Sequence-Number: 15019 NSO wrote: >Well, no. Delphi isn't better, same time just for downloading data... But >as I told before, if for ex. pgAdminIII is running on server machine it is >a lot faster, I do not know why, I was monitoring network connection >between client and server and it is using only up to 2% of full speed.. is >server can't send faster? or client is not accepting data faster? > > Only the first number is relevant and subject to network/db/server issues. The second is GUI only. Regards, Andreas