Re: Performance of jobs - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Performance of jobs
Date
Msg-id 4886073A.7090309@postnewspapers.com.au
Whole thread Raw
In response to Performance of jobs  ("samantha mahindrakar" <sam.mahindrakar@gmail.com>)
Responses Re: Performance of jobs
List 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

pgsql-performance by date:

Previous
From: "samantha mahindrakar"
Date:
Subject: Performance of jobs
Next
From: Patrick Vachon
Date:
Subject: Re: Difference between 8.1 & 8.3