Le 03/12/2010 16:25, Michael Shapiro a écrit :
> I understand, but in this case, since the option is offered next to the safe
> one, most people won't know it isn't safe.
Both are safe. They don't offer the same service. VACUUM will allow
PostgreSQL to reuse dead space, VACUUM FULL will free space on the hard
drive (and have a negative effect on the table's indexes if you don't do
a REINDEX).
> I certainly didn't until I read this posting. I know generally what
> vacuuming does, but I had no idea that postgres offered a potentially
> damaging option. Also, PgAdmin sometimes tells me that a table needs
> vacuuming, so it is already "advising" people in that area ...
Yea, the guru hints. Don't like that and don't really want to extend them.
--
Guillaumehttp://www.postgresql.frhttp://dalibo.com