Re: improve routine vacuuming docs

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: improve routine vacuuming docs
Дата
Msg-id 87smjrqmv6.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на improve routine vacuuming docs  (Neil Conway <neilc@samurai.com>)
Ответы Re: improve routine vacuuming docs
Список pgsql-patches
Robert Treat <xzilla@users.sourceforge.net> writes:
> Should be "TRUNCATE removes the <emphasis>entire</emphasis> content of
> the table immediately, without requiring a subsequent
> <command>VACUUM</command> or <command>VACUUM FULL</command> to
>      reclaim the now-unused disk space."

I think the <emphasis/> is overkill, but otherwise I've made this
change.

> Maybe better is  ..."risk of OID wraparound failures".

Why? XID wraparound and OID wraparound are completely distinct
issues. I think from the context it's pretty clear that XID wraparound
is what is being referred to here.

> What differentiates the first SELECT as a command and the second
> SELECT as a literal?  Some question for CASE really...

Well, the rule-of-thumb is that SQL commands are marked with
<command/>, but clauses of commands or entire example queries are
marked with <literal/>. I think the <literal>CASE</> is correct, but
on closer examination, the second SELECT should probably also be
marked with <command/>.

I've attached a revised patch that incorporates these changes. Thanks
for the feedback!

-Neil

Вложения

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: improve routine vacuuming docs
Следующее
От: "veramente@libero.it"
Дата:
Сообщение: psql-current italian translation updates