| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | samantha mahindrakar <sam(dot)mahindrakar(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance of jobs |
| Date: | 2008-07-22 16:13:46 |
| Message-ID: | 4886073A.7090309@postnewspapers.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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, ...
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2008-07-22 16:48:42 | Re: Perl/DBI vs Native |
| Previous Message | samantha mahindrakar | 2008-07-22 15:44:29 | Performance of jobs |