Re: Excessive vacuum times - Mailing list pgsql-general

From Tom Lane
Subject Re: Excessive vacuum times
Date
Msg-id 8246.1134495848@sss.pgh.pa.us
Whole thread Raw
In response to Re: Excessive vacuum times  (Wes <wespvp@syntegra.com>)
List pgsql-general
Wes <wespvp@syntegra.com> writes:
> Any ideas on how I might I reconfigure to mitigate the issue?  Separating
> the most offending indexes to separate drives probably isn't an option.

What are you using for vacuum_mem?  A larger value should reduce the
number of times we have to scan the indexes of a large table.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Memory Leakage Problem
Next
From: Stephan Szabo
Date:
Subject: Re: Bug#342369: PostgreSQL 8.1.0 RHEL / Debian incompatible