Re: same question little different test MSSQL vrs Postgres

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