Re: Why vacuum?

* 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