Vacuum Times - Verbose and maintenance_work_mem

From: "Y Sidhu" <ysidhu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Vacuum Times - Verbose and maintenance_work_mem
Date: 2007-05-09 22:00:22
Message-ID: b09064f30705091500r248a5becjac15324ca891cf9d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

How do you specify a log file for vacuum verbose to send info to? I have
verbose turned on but cannot see any log messages.

I have upped maintenance_work_mem setting from 32768 to 98304. This is on a
4 GB, 3.2 GHz Xeon, dual core, dual cpu with HTT turned on. I hope that
helps with vacuum times. PG 8.0.9 on a UFS2 FreeBSD 6.2 prerelease.

--
Yudhvir Singh Sidhu
408 375 3134 cell

Browse pgsql-performance by date

  From Date Subject
Next Message Ralph Mason 2007-05-09 23:51:12 Performance Woes
Previous Message Tom Lane 2007-05-09 19:18:12 Re: [PERFORM] Cannot make GIN intarray index be used by the planner