Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

update, truncate and vacuum



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group