Re: Press Release

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Press Release
Дата
Msg-id 200310291424.18086.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Press Release  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Press Release  (Robert Treat <xzilla@users.sourceforge.net>)
Re: Press Release  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-advocacy
Josh,

First of all, be aware that we have already collected half the translations
for the press kit.  So at this point, we can only cut paragraphs and not
edit.  These comments would have been more timely a month ago ....

> I believe is false. As long as you have to vacuum the above is not true.

How?  Vacuuming does not require the database to be offline.  Vacuum full
does, but that can be eliminated with proper tuning.

 Also
> as long as their is a potential that we have to use the reindex command the
above
> isn't true.

But reindex can now be eliminated if the FSM is tuned right.

> Anything that the "system" requires (which does not include transactions)
> that causes a lock for any period of time would invalidate the above.

And the whole point of the FSM feature is that most databases, with proper
tuning, should not require any maintainence which needs exclusive locking.

If anybody has evidence that the FSM index management doens't work, then we'll
cut the paragraph.  However, I'm inclined to trust Tom & Co., and my only
simple tests seemed to uphold the Lazy-Vacuum-ability of indexes.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Press Release
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Press Release