开发者

PostgreSQL: VACUUM FULL or CLUSTER?

I'm nearly out of disk space because of a query that tried to update every row in a huge table. I don't have enough space for CLUSTER (though it would barely fit if I dropped indexes first and recreated them afterwards).

How can I estimate how long VACUUM will take? How about VACUUM FULL? How do the three (with CLUSTER) compare in terms of开发者_StackOverflow社区 running time and disk usage?

It's PostgreSQL 8.3.


use cluster, until 8.4 vacuum full is broke. if it takes to long you might as well dump and reload the table.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜