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?

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.