| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | xuyifeng <xyf(at)stocke(dot)com> |
| Cc: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>, bpalmer <bpalmer(at)crimelabs(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Why vacuum? |
| Date: | 2000-12-14 03:09:23 |
| Message-ID: | 20001213190923.E16205@fw.wintelcom.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* xuyifeng <xyf(at)stocke(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2000-12-14 03:42:08 | RE: Why vacuum? |
| Previous Message | Tom Lane | 2000-12-14 02:35:30 | Re: Bug in ILIKE function? |