[Babase] Speeding up large tables
Karl O. Pinc
kop at meme.com
Sun Mar 29 22:09:48 EDT 2009
On 03/29/2009 08:44:13 PM, Karl O. Pinc wrote:
> I just looked and see that I don't have auto-vacuuming
> on. I had this off for the conversion but really
> think I should turn it on....
I've turned this on (and am vacuuming and analyzing the
databases).
Please let me know if you see any performance problems.
The system will now occasionally spend time cleaning
up the databases. I might have this tuned properly
so that it's not noticeable, and then again I might
not.
I think this may slow down uploads of large data sets,
or more likely the system will slow slightly after
such uploads. Again, let me know if there's problems.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list