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 C1005DA440 for ; Sun, 16 Oct 2005 08:01:51 -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 31893-02 for ; Sun, 16 Oct 2005 11:01:45 +0000 (GMT) Received: from fmf.vtu.lt (fmf.vtu.lt [193.219.145.206]) by svr1.postgresql.org (Postfix) with ESMTP id 93B1FDA43E for ; Sun, 16 Oct 2005 08:01:46 -0300 (ADT) Received: from fmf.vtu.lt (localhost [127.0.0.1]) by fmf.vtu.lt (Postfix) with ESMTP id 852A018473; Sun, 16 Oct 2005 14:01:46 +0300 (EEST) Received: from 81.7.89.65 (SquirrelMail authenticated user nso) by fmf.vtu.lt with HTTP; Sun, 16 Oct 2005 14:01:46 +0300 (EEST) Message-ID: <23627.81.7.89.65.1129460506.squirrel@fmf.vtu.lt> In-Reply-To: <4351DCB6.3040307@paradise.net.nz> 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> Date: Sun, 16 Oct 2005 14:01:46 +0300 (EEST) Subject: Re: Bytea poor performance From: "NSO" To: "Mark Kirkwood" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-VGTU-MailScanner-OpenProtect: Found to be clean X-MailScanner-OpenProtect-MCPCheck: X-MailScanner-OpenProtect-From: nso@fmf.vtu.lt X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.273 required=5 tests=[AWL=-0.101, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/247 X-Sequence-Number: 15015 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... > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > -- > This message has been scanned for viruses and > dangerous content, and is believed to be clean. > > -- This message has been scanned for viruses and dangerous content, and is believed to be clean.