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 по дате отправления: