From: Bruno Wolff III <bruno@wolff.to>
To: Dennis Sacks <dennis@illusions.com>
Cc: Joel Fradkin <jfradkin@wazagua.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: same question little different test MSSQL vrs Postgres
Date: Wed, 26 Jan 2005 15:04:50 -0600
Message-ID: <20050126210450.GA26734@wolff.to> (raw)
In-Reply-To: <41F71AB4.5030208@illusions.com>
References: <000901c5035a$3b619cc0$797ba8c0@jfradkin>
<41F71AB4.5030208@illusions.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, dennis@illusions.com, jfradkin@wazagua.com
Subject: Re: same question little different test MSSQL vrs Postgres
In-Reply-To: <20050126210450.GA26734@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox