Bruno Wolff III wrote:
>On Tue, Jan 25, 2005 at 21:21:08 -0700,
> Dennis Sacks <dennis@illusions.com> 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