| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey Baker | 2008-07-22 20:35:26 | Re: Perl/DBI vs Native |
| Previous Message | Greg Smith | 2008-07-22 17:21:59 | Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) |