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 [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
