Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum-full very slow - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum-full very slow
Date
Msg-id 25112.1177519733@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum-full very slow  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I wonder, though, if you set maintenance_work_mem too high and are
> causing the OS to swap?

AFAIR, vacuum full pays no attention to maintenance_work_mem anyway.
If the data it needs doesn't fit in memory, you lose ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tilmann Singer
Date:
Subject: Re: Audit-trail engine: getting the application's layer user_id
Next
From: Owen Hartnett
Date:
Subject: Schema as versioning strategy