Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuum-full very slow
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Vacuum-full very slow
- Date: Wed, 25 Apr 2007 12:48:53 -0400
Alvaro Herrera <alvherre(at)commandprompt(dot)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
- References:
- Vacuum-full very slow
- From: Steve Crawford
- Re: Vacuum-full very slow
- From: Alvaro Herrera
- Vacuum-full very slow
- Prev by Date: Re: Audit-trail engine: getting the application's layer user_id
- Next by Date: Schema as versioning strategy
- Previous by thread: Re: Vacuum-full very slow
- Next by thread: Schema as versioning strategy
- Indexes: