Re: vacuum vs pg_repack for clearing bloat? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: vacuum vs pg_repack for clearing bloat?
Date
Msg-id 20140116011209.GA22105@crankycanuck.ca
Whole thread Raw
In response to vacuum vs pg_repack for clearing bloat?  (Lists <lists@benjamindsmith.com>)
List pgsql-general
On Wed, Jan 15, 2014 at 04:09:28PM -0800, Lists wrote:
> Our app makes extensive use of temp tables, and this causes a
> significant amount of bloat that can often only be cleared with a

Note what Tom Lane said, but why do you have bloat that can only be
cleared by vacuum?  Why not drop them or whatever (I presume they're
not going away because your connection is long lived)?  They're
supposed to be temporary, after all: cheap and disposable.

A


--
Andrew Sullivan
ajs@crankycanuck.ca


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuum vs pg_repack for clearing bloat?
Next
From: John R Pierce
Date:
Subject: Re: vacuum vs pg_repack for clearing bloat?