From: samantha mahindrakar <sam.mahindrakar@gmail.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance of jobs
Date: Tue, 22 Jul 2008 14:59:55 -0400
Message-ID: <f0c828c40807221159u1ebeaa17q8b6ade2959f00f71@mail.gmail.com> (raw)
In-Reply-To: <4886073A.7090309@postnewspapers.com.au>
References: <f0c828c40807220844w377f4f0k2cc8361856d9a025@mail.gmail.com>
<4886073A.7090309@postnewspapers.com.au>
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
>
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: sam.mahindrakar@gmail.com, craig@postnewspapers.com.au
Subject: Re: Performance of jobs
In-Reply-To: <f0c828c40807221159u1ebeaa17q8b6ade2959f00f71@mail.gmail.com>
* 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