Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuuming of indexes on tables.
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: elein <elein(at)varlena(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Vacuuming of indexes on tables.
- Date: Tue, 18 Apr 2006 09:50:04 -0400
- Message-id: <12663(dot)1145368204(at)sss(dot)pgh(dot)pa(dot)us>
elein <elein(at)varlena(dot)com> writes: > Much later in the day, a vacuum analyze of the > db showed that all of the indexes for that table > required significant vacuuming, although the > table did not. What do you mean by that exactly? If it's just that the index pages emptied by one VACUUM aren't actually recycled till the next one, that's by design. regards, tom lane
- Follow-Ups:
- Re: Vacuuming of indexes on tables.
- From: elein
- Re: Vacuuming of indexes on tables.
- References:
- Vacuuming of indexes on tables.
- From: elein
- Vacuuming of indexes on tables.
- Prev by Date: Re: Syntax Help Requested -- RESOLVED
- Next by Date: Re: Query to check existence of stored procedure?
- Previous by thread: Vacuuming of indexes on tables.
- Next by thread: Re: Vacuuming of indexes on tables.
- Indexes: