Re: [GENERAL] How to identify which query is running - reg.

2004-08-11 Thread Shanmugasundaram Doraisamy
"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 co

Re: [GENERAL] How to identify which query is running - reg.

2004-08-11 Thread Shanmugasundaram Doraisamy
could find it ( the website address). Thanking you, Yours sincerely, Shan. Richard Huxton wrote: Shanmugasundaram Doraisamy wrote: Dear Group, We have a java front-end for postgresql 3.4. Hopefully 7.3.4, otherwise upgrade :-) > When we monitor the system usage using top

[GENERAL] How to identify which query is running - reg.

2004-08-11 Thread Shanmugasundaram Doraisamy
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.

[GENERAL] Need help with Dead Lock - reg.

2004-06-19 Thread Shanmugasundaram Doraisamy
Dear Group, Is there a way to increase the time of Dead Lock? The default is set to 1000 msec. Regards, Shan. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Problem installing postgresql 7.3.6 on Redhat 7.3

2004-04-27 Thread Shanmugasundaram Doraisamy
Dear group, I would like to know where I could find rpms for Redhat 7.3. I have looked at the downloads page and I see only source rpms and rpms for Redhat 9 and FC1. I did download the src rpm and when I run the rpm -ba postgresql.spec I get the following error message:

[GENERAL] Problem with pg_dump - reg.

2004-04-07 Thread Shanmugasundaram Doraisamy
Dear Group, Thanks for all your support to my previous postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I am facing is that when I take a dump of the DB using pg_dump and restore it using the cat pg_dump_file |psql dbname, I find that some views and funct