Skip site navigation (1) Skip section navigation (2)

Re: Performance of jobs

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 (view raw or flat)
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

In response to

Responses

pgsql-performance by date

Next:From: Greg Sabino MullaneDate: 2008-07-22 16:48:42
Subject: Re: Perl/DBI vs Native
Previous:From: samantha mahindrakarDate: 2008-07-22 15:44:29
Subject: Performance of jobs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group