Postgres Pro
Downloads
Home   >   mailing lists

Vacuum Times - Verbose and maintenance_work_mem - Mailing list pgsql-performance

From Y Sidhu
Subject Vacuum Times - Verbose and maintenance_work_mem
Date
Msg-id b09064f30705091500r248a5becjac15324ca891cf9d@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot make GIN intarray index be used by the planner
Next
From: "Ralph Mason"
Date:
Subject: Performance Woes