Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 67410650446 for ; Tue, 22 Jul 2008 16:49:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97386-02 for ; Tue, 22 Jul 2008 16:48:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.29]) by postgresql.org (Postfix) with ESMTP id F16326507FC for ; Tue, 22 Jul 2008 15:59:59 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so775412ywj.73 for ; Tue, 22 Jul 2008 11:59:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=L7vMwA8PJdgVXApFkUItW1Uh99C1I8god4mio1ym380=; b=W888xlq4/m1Wi7fIlaF7T/C2SJnYpqT91Kya539R8z2XKgtG+r1wnP4kqf3DRqI2aC UopZDn7bL6SkIXHzOdoT6e9ynkJAnPA54M+z0X3emLHyOA3LcayyEl9ueX461x0ofIkE 1rUStIHltX2SWhhbNceePxmeJx1PN6KIlCuqY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=mxM27Lfua5nrYlX6r2ZFmOAndPpB61Tc6930F5dz24fWgy0xIuJKShHjTbTNlqoGqX TdYXfWWwiU7jr+tIrcxkFPYIlxm3XJ7p3c12tLmkw/8qByqqH/ywGtvm+vdc67uxQpFe OypnZCUkfA2t5E36uc3STzE4Lx4YufGN2hL50= Received: by 10.115.50.5 with SMTP id c5mr4064753wak.192.1216753195185; Tue, 22 Jul 2008 11:59:55 -0700 (PDT) Received: by 10.114.183.2 with HTTP; Tue, 22 Jul 2008 11:59:55 -0700 (PDT) Message-ID: Date: Tue, 22 Jul 2008 14:59:55 -0400 From: "samantha mahindrakar" To: "Craig Ringer" Subject: Re: Performance of jobs Cc: pgsql-performance@postgresql.org In-Reply-To: <4886073A.7090309@postnewspapers.com.au> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_111486_24202024.1216753195173" References: <4886073A.7090309@postnewspapers.com.au> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/207 X-Sequence-Number: 30807 ------=_Part_111486_24202024.1216753195173 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Windows 2003 Server SP2 Intel Xeon 3.2 GHz 3.75 Gb RAM System Drive 33.8 Gb Data drive 956 Gb PostgreSQL 8.2.6 PERC RAID 10 I believe SCSI disks On 7/22/08, Craig Ringer wrote: > > 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 > ------=_Part_111486_24202024.1216753195173 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Windows 2003 Server SP2
Intel Xeon 3.2 GHz
3.75 Gb RAM
System Drive 33.8 Gb
Data drive 956 Gb
PostgreSQL 8.2.6
PERC RAID 10 I believe SCSI disks
 
 

 
On 7/22/08, Craig Ringer <craig@postnewspapers.com.au> wrote:
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

------=_Part_111486_24202024.1216753195173--