Ah! Truncating a table does not entail all of WAL processes. From the documentation, "TRUNCATEquickly removes all rows from a set of tables. It has the same effect as an unqualifiedDELETEon each table, but since it does not actually scan the tables it is faster. Furthermore, it reclaims disk space immediately, rather than requiring a subsequentVACUUMoperation. This is most useful on large tables." https://www.postgresql.org/docs/14/sql-truncate.html
Regards,
Gus
On Sun, Jul 23, 2023 at 5:51 AM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On 2023-07-22 16:37:39 -0400, Gus Spier wrote: > Isn’t this a perfect opportunity to use the TRUNCATE command to > quickly remove the data? And follow up by deleting the now empty > tables?
What's the advantage of first truncating and then deleting a table over just deleting it?
hp
-- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"