[Babase] Speeding up large tables

Karl O. Pinc kop at meme.com
Sun Mar 29 21:44:13 EDT 2009


On 03/29/2009 02:12:43 PM, Karl O. Pinc wrote:
> Catherine,
> 
> You probably want to put some indexes on your
> big tables.  It will make things much, much
> faster.

I can't recall if I've auto-vacuuming turned on.
If not then you'll want to "vacuum analyze" the table
after you delete or modify a lot of rows, add columns, etc.

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....

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