Re: same question little different test MSSQL vrs Postgres

From: Dennis Sacks <dennis(at)illusions(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Joel Fradkin <jfradkin(at)wazagua(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: same question little different test MSSQL vrs Postgres
Date: 2005-01-26 20:57:32
Message-ID: 41F8043C.6080101@illusions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruno Wolff III wrote:

>On Tue, Jan 25, 2005 at 21:21:08 -0700,
> Dennis Sacks <dennis(at)illusions(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-01-26 21:04:50 Re: same question little different test MSSQL vrs Postgres
Previous Message Bruno Wolff III 2005-01-26 20:13:19 Re: datediff is there something like it?