public inbox for [email protected]
help / color / mirror / Atom feedFrom: Devrim GÜNDÜZ <[email protected]>
To: pgsql-docs <[email protected]>
Subject: Doc patch for truncate.sgml
Date: Thu, 28 Aug 2008 18:14:47 +0300
Message-ID: <[email protected]> (raw)
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
Attachments:
[text/x-patch] truncate-sgml.patch (1.3K, 2-truncate-sgml.patch)
download | inline diff:
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>
[application/pgp-signature] signature.asc (197B, 3-signature.asc)
download
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Doc patch for truncate.sgml
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox