| From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Monitoring locks |
| Date: | 2005-05-12 08:05:24 |
| Message-ID: | 20050512080524.12473.qmail@web51001.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I wanted to see which tables/transaction have acquired or are waiting for which locks....
as far as i know there are two ways to do it....
1) pg_locks ::: but we need to continously keep getting data from the table and it also locks lock manager data structures which is not a good thing to do...
2) trace_locks,trace_lwlocks ... etc etc.... ::: well for this my server says undefined parameters... so as far as i know i need to rebuild the server with some flag...
is there any other better way by which i can get a list of locks acquired and waited for during entire run of my application....
thx
Himanshu
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lang | 2005-05-12 08:41:45 | Delphi 2005, Postgresql, ZEOS & optimistic locking |
| Previous Message | Patrick.FICHE | 2005-05-12 08:01:34 | pgadmin on Solaris |