Message-ID: <41F8043C.6080101@illusions.com>
Date: Wed, 26 Jan 2005 13:57:32 -0700
From: Dennis Sacks <dennis@illusions.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
MIME-Version: 1.0
To: Bruno Wolff III <bruno@wolff.to>
Cc: Joel Fradkin <jfradkin@wazagua.com>, pgsql-sql@postgresql.org
Subject: Re: same question little different test MSSQL vrs Postgres
References: <000901c5035a$3b619cc0$797ba8c0@jfradkin>
	<41F71AB4.5030208@illusions.com> <20050126210450.GA26734@wolff.to>
In-Reply-To: <20050126210450.GA26734@wolff.to>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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