pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhy different execution times for different instances for the same query?
2+ messages / 2 participants
[nested] [flat]
* Why different execution times for different instances for the same query?
@ 2005-10-25 20:18 Kishore B <kishorebh@gmail.com>
2005-10-25 20:44 ` Re: Why different execution times for different instances for the same query? Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kishore B @ 2005-10-25 20:18 UTC (permalink / raw)
To: pgsql-admin
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 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 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Why different execution times for different instances for the same query?
2005-10-25 20:18 Why different execution times for different instances for the same query? Kishore B <kishorebh@gmail.com>
@ 2005-10-25 20:44 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jim C. Nasby @ 2005-10-25 20:44 UTC (permalink / raw)
To: Kishore B <kishorebh@gmail.com>; +Cc: pgsql-admin
It's impossible to say without more information. What's the query that's
slow? What's EXPLAIN ANALYZE of that query show? How often are you
vacuuming? How often are you analyzing? What postgresql.conf options
have you changed from the defaults? What hardware is this running on?
The memory usage you're seeing is most likely just the OS reporting
shared memory as if it was being used by each backend, even though it's
just one set of memory that's shared between all the processes.
On Wed, Oct 26, 2005 at 01:48:16AM +0530, Kishore B wrote:
> 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 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 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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-10-25 20:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-25 20:18 Why different execution times for different instances for the same query? Kishore B <kishorebh@gmail.com>
2005-10-25 20:44 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox