Bruno Wolff III wrote:
On Tue, Jan 25, 2005 at 21:21:08 -0700,
Dennis Sacks <[EMAIL PROTECTED]> wrote:
One of the things you'll want to do regularly is run a "vacuum analyze".
You can read up on this in the postgresql docs. This is essential to the
indexes being used properly. At a bare minimum, after you import a large
amount of data, you'll want to run vacuum analyze.
Note that there is no need to vacuum after inserts (only updates and deletes),
so you can just do an analyze in that case.
Good point! Analyze after bulk inserts, vacuum analyze after
updates/deletes and inserts. :)
Dennis Sacks
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
