Re: Why pgAdmin III guru suggests VACUUM in 8.1 - Mailing list pgsql-general

From Andrus
Subject Re: Why pgAdmin III guru suggests VACUUM in 8.1
Date
Msg-id dmku6j$1emi$1@news.hub.org
Whole thread Raw
In response to Why pgAdmin III guru suggests VACUUM in 8.1  ("Andrus Moor" <eetasoft@online.ee>)
List 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.



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: What is the deal with mailing lists?
Next
From: Scott Marlowe
Date:
Subject: Re: How to change database owner in 7.4