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 6EC27DA2AC for ; Sun, 16 Oct 2005 01:53: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 37770-05 for ; Sun, 16 Oct 2005 04:53:15 +0000 (GMT) Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [203.96.152.183]) by svr1.postgresql.org (Postfix) with ESMTP id 550F3D8E8E for ; Sun, 16 Oct 2005 01:53:15 -0300 (ADT) Received: from smtp-3.paradise.net.nz ([203.96.152.177]) by linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IOF00A68S8QIZ@linda-4.paradise.net.nz> for pgsql-performance@postgresql.org; Sun, 16 Oct 2005 17:53:14 +1300 (NZDT) Received: from [192.168.1.11] (218-101-13-49.paradise.net.nz [218.101.13.49]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id D595F13BB192; Sun, 16 Oct 2005 17:53:13 +1300 (NZDT) Date: Sun, 16 Oct 2005 17:53:10 +1300 From: Mark Kirkwood Subject: Re: Bytea poor performance In-reply-to: <18133.81.7.89.65.1129392990.squirrel@fmf.vtu.lt> To: NSO Cc: pgsql-performance@postgresql.org Message-id: <4351DCB6.3040307@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050726) 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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.124 required=5 tests=[AWL=0.124] X-Spam-Level: X-Archive-Number: 200510/246 X-Sequence-Number: 15014 NSO wrote: > Hello, > > Yes, I can understand that, but then why the same app on the server > machine is done in 4 seconds? (big difference from 20-30 seconds). I > tryed to monitor network traffic and it is used only for 1-2% of total > 100mbit. > Is this a web app? If so, then check you are using the same browser settings on the server and client (or the same browser for that matter). Note that some browsers really suck for large (wide or long) table display! cheers Mark