Re: same question little different test MSSQL vrs Postgres

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Sacks <dennis(at)illusions(dot)com>
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 21:04:50
Message-ID: 20050126210450.GA26734@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-01-26 21:45:19 Re: testing/predicting optimization using indexes
Previous Message Dennis Sacks 2005-01-26 20:57:32 Re: same question little different test MSSQL vrs Postgres