Re: Performance of jobs

------=_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 <craig@[EMAIL PROTECTED]
> 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

<div>Windows 2003 Server SP2<br>Intel Xeon 3.2 GHz<br>3.75 Gb
RAM<br>System Drive 33.8 Gb<br>Data drive 956 Gb<br>PostgreSQL
8.2.6<br>PERC RAID 10 I believe SCSI disks<br>&nbsp;</div>
<div>&nbsp;</div>
<div><br>&nbsp;</div>
<div><span class="gmail_quote">On 7/22/08, <b
class="gmail_sendername">Craig Ringer</b> &lt;<a
href="mailto:craig@[EMAIL PROTECTED]
">craig@[EMAIL PROTECTED]
>&gt;
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span class="q">samantha
mahindrakar wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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?<br>
</blockquote><br></span>What is your hardware? OS? OS version? PostgreSQL
version? Number of disks, disk type, disk/RAID controller, RAID/LVM
configuration, ...<br><br>--<br><span class="sg">Craig
Ringer<br></span></blockquote>
</div><br>

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