Postgres Pro
Downloads
Home   >   mailing lists

Re: same question little different test MSSQL vrs Postgres - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: same question little different test MSSQL vrs Postgres
Date
Msg-id 20050126210450.GA26734@wolff.to
Whole thread Raw
In response to Re: same question little different test MSSQL vrs Postgres  (Dennis Sacks <dennis@illusions.com>)
Responses Re: same question little different test MSSQL vrs Postgres  (Dennis Sacks <dennis@illusions.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: datediff is there something like it?
Next
From: Dennis Sacks
Date:
Subject: Re: same question little different test MSSQL vrs Postgres