Thread: Vacuum Times - Verbose and maintenance_work_mem

Vacuum Times - Verbose and maintenance_work_mem

From
"Y Sidhu"
Date:
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