From: Craig Ringer <craig@postnewspapers.com.au>
To: samantha mahindrakar <sam.mahindrakar@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance of jobs
Date: Wed, 23 Jul 2008 00:13:46 +0800
Message-ID: <4886073A.7090309@postnewspapers.com.au> (raw)
In-Reply-To: <f0c828c40807220844w377f4f0k2cc8361856d9a025@mail.gmail.com>
References: <f0c828c40807220844w377f4f0k2cc8361856d9a025@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, sam.mahindrakar@gmail.com
Subject: Re: Performance of jobs
In-Reply-To: <4886073A.7090309@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox