Re: Why pgAdmin III guru suggests VACUUM in 8.1

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why pgAdmin III guru suggests VACUUM in 8.1
Date: 2005-11-30 19:22:50
Message-ID: dmku6j$1emi$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> I need to create installation for dumb users to ship DBMS with my
>> application.
>> So manual initial tuning is not possible.
>>
>
> Some tuning is... for instance during installation you should run vacuum
> analyze after loading your data in.

My application runs ANALYZE command programmatically after data loading.
So end user does not need to run it.

Autovacuum is turned ON by default.
Why I should to run VACUUM ANALYZE in this case ?
ANALYZE must be sufficient.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-11-30 19:30:55 Re: Finding uniques across a big join
Previous Message Tom Lane 2005-11-30 19:12:08 Re: [GENERAL] What is the deal with mailing lists?