samantha mahindrakar wrote:
> I am facing performance issues with running scheduled jobs. There are
> multiple jobs running on the database ...not necessarily acting on the
> same table. Either ways i checked if there was a locking issue, I did
> not find any conflicting issues. The program is run over night
> ......when i check the log files i saw that it runs slow when other
> loaders are running.Is there any way i can improve the performance?Can
> someone help me understand how to debug this bottle neck?
What is your hardware? OS? OS version? PostgreSQL version? Number of
disks, disk type, disk/RAID controller, RAID/LVM configuration, ...
In response to
pgsql-performance by date
|Next:||From: Greg Sabino Mullane||Date: 2008-07-22 16:48:42|
|Subject: Re: Perl/DBI vs Native|
|Previous:||From: samantha mahindrakar||Date: 2008-07-22 15:44:29|
|Subject: Performance of jobs|