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 99D91D9C40 for ; Thu, 29 Sep 2005 13:17:16 -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 81607-04 for ; Thu, 29 Sep 2005 16:17:07 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 248A1D9C3F for ; Thu, 29 Sep 2005 13:17:06 -0300 (ADT) Received: (qmail 5214 invoked from network); 29 Sep 2005 18:17:57 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 29 Sep 2005 18:17:57 +0200 To: Joe , "Gavin Sherry" Cc: "Magnus Hagander" , pgsql-performance@postgresql.org Subject: Re: Comparative performance References: <6BCB9D8A16AC4241919521715F4D8BCE92E6D6@algol.sollentuna.se> <433BDB0B.8010002@freedomcircle.net> <433BE1A0.5000807@freedomcircle.net> Message-ID: Date: Thu, 29 Sep 2005 18:17:05 +0200 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <433BE1A0.5000807@freedomcircle.net> User-Agent: Opera M2/8.0 (Linux, build 1095) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/425 X-Sequence-Number: 14733 > Total runtime: 16.000 ms Even though this query isn't that optimized, it's still only 16 milliseconds. Why does it take this long for PHP to get the results ? Can you try pg_query'ing this exact same query, FROM PHP, and timing it with getmicrotime() ? You can even do an EXPLAIN ANALYZE from pg_query and display the results in your webpage, to check how long the query takes on the server. You can also try it on a Linux box. This smells like a TCP communication problem.