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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support