From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Kishore B <bkishorevarma(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why different execution times for different instances for the |
Date: | 2005-10-25 20:33:32 |
Message-ID: | 1130272412.3978.1.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2005-10-25 at 13:14 -0700, Kishore B wrote:
> Hi ,
> 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
>
>
>
> 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.
No, I haven't seen anything like that.
I am forwarding this mail to the general enquiries list, in case anyone
else can help.
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
From | Date | Subject | |
---|---|---|---|
Next Message | Noel Whelan | 2005-10-25 20:46:52 | improve 'where not exists' query.. |
Previous Message | Peter Wiersig | 2005-10-25 20:15:22 | Re: Installation Problem |