Re: Eliminating VACUUM FULL WAS: remove flatfiles.c

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Eliminating VACUUM FULL WAS: remove flatfiles.c
Дата
Msg-id 1252092444.18360.0.camel@jd-desktop.iso-8859-1.charter.com
обсуждение исходный текст
Ответ на Re: Eliminating VACUUM FULL WAS: remove flatfiles.c  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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.

Joshua D. Drake


> 
>             regards, tom lane
> 
-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: match_unsorted_outer() vs. cost_nestloop()
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Eliminating VACUUM FULL WAS: remove flatfiles.c