Re: Eliminating VACUUM FULL WAS: remove flatfiles.c

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Eliminating VACUUM FULL WAS: remove flatfiles.c
Дата
Msg-id 20090904192818.GL5603@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Eliminating VACUUM FULL WAS: remove flatfiles.c  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Eliminating VACUUM FULL WAS: remove flatfiles.c  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Joshua D. Drake escribió:
> On Fri, 2009-09-04 at 15:10 -0400, Tom Lane wrote:
> > Robert Haas <robertmhaas@gmail.com> writes:
> > > I'm confused.  Are you saying that pg_class will never get bloated, so
> > > we don't need a way to debloat it?  I realize that with HOT bloat is
> > > much less of a problem than it used to be, but surely it's not
> > > altogether impossible...
> > 
> > Well, it's certainly *possible*, I'm just questioning the assertion that
> > it's necessarily a common situation.
> 
> Depends on your definition of common. It is very easy for someone to
> blow away their vacuum settings in such a way that it will become
> bloated pretty quick.

No problem, just CLUSTER that table same as today.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Eliminating VACUUM FULL WAS: remove flatfiles.c
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Eliminating VACUUM FULL WAS: remove flatfiles.c