Re: Performance of jobs

Поиск
Список
Период
Сортировка
От samantha mahindrakar
Тема Re: Performance of jobs
Дата
Msg-id f0c828c40807221159u1ebeaa17q8b6ade2959f00f71@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of jobs  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: Performance of jobs
Список 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@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

В списке pgsql-performance по дате отправления: