Postgres Pro
Downloads
Home   >   mailing lists

Re: After how many updates should a vacuum be performed? - Mailing list pgsql-admin

From Tom Lane
Subject Re: After how many updates should a vacuum be performed?
Date
Msg-id 13301.1158166441@sss.pgh.pa.us
Whole thread Raw
In response to Re: After how many updates should a vacuum be performed?  (Ellen Cyran <ellen@urban.csuohio.edu>)
Responses Re: After how many updates should a vacuum be performed?  (Ellen Cyran <ellen@urban.csuohio.edu>)
List pgsql-admin
Tree view 
Ellen Cyran <ellen@urban.csuohio.edu> writes:
> Tom Lane wrote:
>> By "vacuum" do you mean VACUUM FULL?

> No, I mean vacuum analyze.

Hm, that should be OK.  What do you have maintenance_work_mem set to?

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY FROM command v8.1.4
Next
From: Ellen Cyran
Date:
Subject: Re: After how many updates should a vacuum be performed?