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

Re: Performance of jobs

From: "samantha mahindrakar" <sam(dot)mahindrakar(at)gmail(dot)com>
To: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of jobs
Date: 2008-07-22 18:59:55
Message-ID: f0c828c40807221159u1ebeaa17q8b6ade2959f00f71@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)postnewspapers(dot)com(dot)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
>

In response to

Responses

pgsql-performance by date

Next:From: Jeffrey BakerDate: 2008-07-22 20:35:26
Subject: Re: Perl/DBI vs Native
Previous:From: Greg SmithDate: 2008-07-22 17:21:59
Subject: Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)

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