[ADMIN] Multiple locks problem

2008-07-17 Thread samantha mahindrakar
Hi Below is the locks that are generated by my program. Can someone thrown some light as to why i see multiple locks on the same table?. I first insert data in the table 'imputed_prediction' and the select data from it..since i see locks on indexes.iam assuming i

Re: [ADMIN] Jobs using pgagent

2008-07-16 Thread samantha mahindrakar
I think the log file would be too big to post since the program runs for hourshowever you are right...i did some analysis and found that the program runs slwo when another loader is running. If the loader has run for 2-3 hours...the pro gram has run extremely slow at that timean

[ADMIN] Jobs using pgagent

2008-07-15 Thread samantha mahindrakar
Hi Iam using postgres since recently.there are jobs scheduled using the pgagent. There are loaders and stuff that are scheduled using the pgagent. There is a new job that i have addedthe weird part is that it runs for different amounts of time everyday. For example: it has run f