Re: Auto Vacuum Problem - Mailing list pgsql-performance

From Heiko W.Rupp
Subject Re: Auto Vacuum Problem
Date
Msg-id 729B02C7-87D1-4C69-A171-22483668D83A@redhat.com
Whole thread Raw
In response to Auto Vacuum Problem  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
List pgsql-performance
Hi,

> How do I make the physical size of the DB smaller without doing a
> full vacuum.

This might turn out to be counterproductive, as subsequent inserts
and updates will increase
the size of the physical database again, which might be expensive
depending on the underlying OS.
--
Heiko W.Rupp
heiko.rupp@redhat.com, http://www.dpunkt.de/buch/3-89864-429-4.html




pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Auto Vacuum Problem
Next
From: "Shoaib Mir"
Date:
Subject: Re: slow result