Re: After how many updates should a vacuum be performed?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: After how many updates should a vacuum be performed?
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 13 Sep 2006 12:54:01 -0400
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Comments: In-reply-to Ellen Cyran <ellen@xxxxxxxxxxxxxxxxx> message dated "Wed, 13 Sep 2006 12:31:48 -0400"
In-reply-to: <45083274.902@xxxxxxxxxxxxxxxxx>
References: <45082C83.5040206@xxxxxxxxxxxxxxxxx> <12738.1158164349@xxxxxxxxxxxxx> <45083274.902@xxxxxxxxxxxxxxxxx>

Ellen Cyran <ellen@xxxxxxxxxxxxxxxxx> 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

Follow-Ups:
- Re: After how many updates should a vacuum be performed?
  - From: Ellen Cyran

References:
- After how many updates should a vacuum be performed?
  - From: Ellen Cyran
- Re: After how many updates should a vacuum be performed?
  - From: Tom Lane
- Re: After how many updates should a vacuum be performed?
  - From: Ellen Cyran

Prev by Date: Re: COPY FROM command v8.1.4
Next by Date: Re: After how many updates should a vacuum be performed?
Previous by thread: Re: After how many updates should a vacuum be performed?
Next by thread: Re: After how many updates should a vacuum be performed?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux