Why different execution times for different instances for the same query? - Mailing list pgsql-performance

From Kishore B
Subject Why different execution times for different instances for the same query?
Date
Msg-id 42567e060510251246s1b9eda40l54e73993f8bcfb34@mail.gmail.com
Whole thread Raw
Responses Re: Why different execution times for different
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Rich Doughty
Date:
Subject: Re: Outer join query plans and performance
Next
From: Scott Marlowe
Date:
Subject: Re: Why different execution times for different