Thursday, August 28, 2008

[DOCS] Doc patch for truncate.sgml

Index: doc/src/sgml/ref/truncate.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/truncate.sgml,v
retrieving revision 1.27
diff -c -r1.27 truncate.sgml
*** doc/src/sgml/ref/truncate.sgml 17 May 2008 23:36:27 -0000 1.27
--- doc/src/sgml/ref/truncate.sgml 28 Aug 2008 14:58:16 -0000
***************
*** 34,40 ****
<command>DELETE</command> on each table, but since it does not actually
scan the tables it is faster. Furthermore, it reclaims disk space
immediately, rather than requiring a subsequent <command>VACUUM</command>
! operation. This is most useful on large tables.
</para>
</refsect1>

--- 34,44 ----
<command>DELETE</command> on each table, but since it does not actually
scan the tables it is faster. Furthermore, it reclaims disk space
immediately, rather than requiring a subsequent <command>VACUUM</command>
! operation. This is most useful on large tables. Also,
! <command>TRUNCATE</command> rewrites system catalogue entries for
! that table, which makes running <command>ANALYZE</command> on a
! freshly-truncated table is a bad idea, because the statistics will be
! updated to indicate that the table is truly empty.
</para>
</refsect1>

Attached is a doc patch for truncate.sgml. It improves info for
TRUNCATE. Thanks to Andrew Sullivan for pointing out this.

This is against head, but could be backpatched, too, I believe.

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

No comments: