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 27D17DAE3F for ; Tue, 25 Oct 2005 16:46:53 -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 99519-01 for ; Tue, 25 Oct 2005 19:46:50 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by svr1.postgresql.org (Postfix) with ESMTP id 13707DAE55 for ; Tue, 25 Oct 2005 16:46:50 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so825935nzo for ; Tue, 25 Oct 2005 12:46:52 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=k3nsPC5pC5mE9qyHfdEfqrAOv8SHU4yDM0GnpO/iAJjt5HVmyEeHEap+5X4iCwXZnSQP7ow3BAWf81OxxfXhHkIt/E3ZZP2JLzHcnbxcKuVOrLnPrJ0la6yrs8HdgtpMDIvuyww8OCDnPw2T1cqwLA4ip9ja/UWWKzLZQlOD+Fc= Received: by 10.36.9.19 with SMTP id 19mr89519nzi; Tue, 25 Oct 2005 12:46:52 -0700 (PDT) Received: by 10.36.61.1 with HTTP; Tue, 25 Oct 2005 12:46:52 -0700 (PDT) Message-ID: <42567e060510251246s1b9eda40l54e73993f8bcfb34@mail.gmail.com> Date: Wed, 26 Oct 2005 01:16:52 +0530 From: Kishore B To: pgsql-performance@postgresql.org Subject: Why different execution times for different instances for the same query? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7717_21674086.1130269612673" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.469 required=5 tests=[AWL=-0.060, HTML_20_30=0.504, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/371 X-Sequence-Number: 15139 ------=_Part_7717_21674086.1130269612673 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All, We are executing a single query that returned very fast on the first instance. But when I executed the same query for multiple times, it is giving strange results. It is not coming back. When I checked with the processes running in the system, I observed that multiple instances of postmaster are running and all of them are consuming very high amounts of memory. I could also observe that they are sharing the memory in a uniform distribution across them. Please let me know if any body has experienced the same and how do they resolved it. Thank you, Kishore. ------=_Part_7717_21674086.1130269612673 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi All,
 
We are executing a single query that returned very fast on the fi= rst instance. But when I executed the same query for multipl= e times, it is giving strange results. It is not coming back. 
 
When I checked with the processes running in the system, I observ= ed that multiple instances of postmaster are running and all of them are co= nsuming very high amounts of memory. I could also observe that they are sha= ring the memory in a uniform distribution across them.=20
 
Please let me know if any body has experienced the same and how do the= y resolved it.
 
Thank you,
Kishore.
------=_Part_7717_21674086.1130269612673--