From: Scott Feldstein <scott.feldstein@hyperic.com>
To: pgsql-performance@postgresql.org
Subject: update, truncate and vacuum
Date: Thu, 26 Jul 2007 15:36:50 -0700
Message-ID: <B195EEA2-7B5D-444F-8F48-46BB88FCFFA8@hyperic.com> (raw)
Hi,
I have a couple questions about how update, truncate and vacuum would
work together.
1) If I update a table foo (id int, value numeric (20, 6))
with
update foo set value = 100 where id = 1
Would a vacuum be necessary after this type of operation since the
updated value is a numeric? (as opposed to a sql type where its size
could potentially change i.e varchar)
2) After several updates/deletes to a table, if I truncate it, would
it be necessary to run vacuum in order to reclaim the space?
thanks,
Scott
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: pgsql-performance@postgresql.org
Cc: scott.feldstein@hyperic.com
Subject: Re: update, truncate and vacuum
In-Reply-To: <B195EEA2-7B5D-444F-8F48-46BB88FCFFA8@hyperic.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox