From: | Shanmugasundaram Doraisamy <shan(at)ceedees(dot)com> |
---|---|
To: | Jan Poslusny <pajout(at)gingerall(dot)cz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to identify which query is running - reg. |
Date: | 2004-08-12 05:07:50 |
Message-ID: | 411AFB26.30603@ceedees.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Jan Poslusny,
Thank you for you immediate reply, in
regards to the shared_buffers, what is the optimum value and how do I
calculate it. Thanking you,
Yours sincerely,
Shan.
Jan Poslusny wrote:
> Hi Shan,
> please, check your postgresql.conf and find "shared_buffers" and
> "log_statement". I am not 100% sure, if statements are logged before
> executing.
>
> Regards,
> pajout
>
> Shanmugasundaram Doraisamy wrote:
>
>> Dear Group,
>> We have a java front-end for postgresql 3.4.
>> When we monitor the system usage using top we find couple of
>> postmasters taking up close to 90% of the CPU time in total. I would
>> like to know which are the queries that are currently running at this
>> point of time. How do we do this?? Another thing that I have
>> noticed is that when I give df -h, I find there is a partition
>> /dev/shm which is somewhere in the range of about 128MB and never
>> used. What is this supposed to be. Is it being not used a good sign
>> or am I loosing on my performance? How do we get it to be used by the
>> database if it will help improve the performance. Thanks in advance.
>>
>> Yours sincerely,
>> Shan.
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2004-08-12 06:20:36 | upgrading in RH 8 |
Previous Message | Shanmugasundaram Doraisamy | 2004-08-12 04:33:57 | Re: How to identify which query is running - reg. |