Re: Default fill factor for tables?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Default fill factor for tables?
Дата
Msg-id 1215811441.4051.1664.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Default fill factor for tables?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Default fill factor for tables?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
On Fri, 2008-07-11 at 14:51 -0600, Scott Marlowe wrote:

> I would kindly disagree.  I'm looking at a project where HOT updates
> are going to be a real performance enhancement, but I'll have to
> create a hundred or so tables ALL with fillfactor tacked on the end.

You clearly think that adjusting fillfactor helps in all cases with HOT.
I disagree with that, else would have pushed earlier for exactly what
you suggest. In fact, I've has this exact discussion previously.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


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

Предыдущее
От: William Garrison
Дата:
Сообщение: How do I tell if a vacuum is currently running?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: recovery do not finish