Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I got dedicated disk (RAID 10 - 4 SAS disks) for Postgres. I am bit worried as recently, I see under Windows Resource Manager disk queues like 3+ in the mornings (low traffic hours), like every 30-60 seconds. I checked what queries are running, started logging queries 1000ms+ but I cannot see what is causing this traffic. It looks like transaction log is saving most data, but I've read xlog to another disk will only give max 20% performance gain. I was thinking about some triggers added recently, but I am not sure how to check it.

Can you give me any tips how to find what is causing this traffic?

share|improve this question
3  
Autovaccum activity? Enable autovacuum logging, checkpoint logging, query logging, etc. See postgresql.org/docs/current/static/… . Related docs cover other logging options. –  Craig Ringer Nov 14 '12 at 9:47
    
I don't think it's autovacuum, but maybe... I enabled checkpoint logging as it was missing before. –  Michal Nov 15 '12 at 11:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.