X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 22B0FDADAF for ; Tue, 25 Oct 2005 17:18:20 -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 03642-07 for ; Tue, 25 Oct 2005 20:18:14 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by svr1.postgresql.org (Postfix) with ESMTP id 11B39DAC4F for ; Tue, 25 Oct 2005 17:18:14 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so829926nzo for ; Tue, 25 Oct 2005 13:18:17 -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=AMQtD6OuslR6JxHH5I3q+3rQCG/L+jGstW9UkzeDTFagJnfe/2d/6CfKvNibcMU3LxuMnKqDc3S7+hKCaGiCzxgn4kNxWNckEbZpGK3DjT5/eKOweB6oySOxifcc5+FZE69XSAzR+DhBHfvHC7J8yP1Id17UkQJ2djfq3xxMd44= Received: by 10.36.222.7 with SMTP id u7mr78032nzg; Tue, 25 Oct 2005 13:18:16 -0700 (PDT) Received: by 10.36.61.1 with HTTP; Tue, 25 Oct 2005 13:18:16 -0700 (PDT) Message-ID: <42567e060510251318n747e0cf8m311210c3e4434bf3@mail.gmail.com> Date: Wed, 26 Oct 2005 01:48:16 +0530 From: Kishore B To: "pgsql-admin@postgresql.org" Subject: Why different execution times for different instances for the same query? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7941_3245377.1130271496965" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.507 required=5 tests=[AWL=-0.083, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024, TO_ADDRESS_EQ_REAL=0.47] X-Spam-Level: X-Archive-Number: 200510/266 X-Sequence-Number: 19338 ------=_Part_7941_3245377.1130271496965 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All, I am Kishore doing freelance development of J2EE applications. We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill recently, untill we began working on an application that needs to maintain a huge database. I am describing the problem we are facing below. Can you please take a loo= k at the case, and help me in resolvign the issue. 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. Can you please let me know if you have experienced the same and how do you resolved it? Thank you, Kishore. ------=_Part_7941_3245377.1130271496965 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Hi All,

 

I am Kishore doing freelance development of J2EE applications.

 

We switched to use Postgresql recently because of the advantages = it has over other commercial databases. All went well untill recently, unti= ll we began working on an application that needs to maintain  a huge d= atabase.=20

 

I am describing the problem we are facing below. Can you please t= ake a look at the case, and help me in resolvign the issue.

 

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 str= ange results. It is not coming back. 
 
When I checked with the p= rocesses running in the system, I observed that multiple instances of = postmaster are running and all of them are consuming very high amounts of m= emory. I could also observe that they are sharing the memory in a uniform d= istribution across them.=20
 
Can you please let me kno= w if you have experienced the same and how do you resolved it?
 
Thank you,
Kishore. 
------=_Part_7941_3245377.1130271496965--