Re: vacuum vs pg_repack for clearing bloat?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum vs pg_repack for clearing bloat?
Date: 2014-01-16 01:12:15
Message-ID: 20140116011209.GA22105@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-01-16 01:33:19 Re: vacuum vs pg_repack for clearing bloat?
Previous Message Tom Lane 2014-01-16 00:24:02 Re: vacuum vs pg_repack for clearing bloat?