On Mon, Jun 04, 2007 at 04:15:12AM -0700, ivan.hou@xxxxxxxxxxxxx wrote: > after i executed the command " vaccumdb -f -z testdb", but the size > just decreased 1 or 2MB... > what's the problem? vacuumdb -f does a FULL vacuum, which is blocking and compacts the tables. If it only compacted 1 or 2 M, then there are two possibilities: 1. You really do have that much data. You haven't told us anything about the data, what it looks like, how wide the tables are, whether you have large objects &c., whether the character set is multibyte. . . 2. You have at least one long-running transaction that is perhaps doing nothing, but that is preventing VACUUM from recovering space. What does ps -auxww | grep postgres (or something equivalant) show you? A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz
