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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
Autovaccum activity? Enable autovacuum logging, checkpoint logging, query logging, etc. See… . 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

Your Answer


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

Browse other questions tagged or ask your own question.