* xuyifeng <xyf@stocke.com> [001213 18:54] wrote:
> I have this nasty problem too, in early time, I don't know the problem, but we used it for a while,
> than we found our table growing too fast without insert any record( we use update), this behaviour
> most like M$ MSACCESS database I had used a long time ago which don't reuse deleted record
> space and full fill your hard disk after several hours, the nasty vaccum block any other users to operate
> on table, this is a big problem for a large table, because it will block tooo long to let other user to run
> query. we have a project affected by this problem, and sadly we decide to use closure source database
> - SYBASE on linux, we havn't any other selections. :(
>
> note that SYBASE and Informix both have 'update statistics' command, but they run it fast in seconds,
> not block any other user, this is pretty. ya, what's good technology!
http://people.freebsd.org/~alfred/vacfix/
-Alfred