Re: Auto Vacuum Problem

From: "Heiko W(dot)Rupp" <heiko(dot)rupp(at)redhat(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Auto Vacuum Problem
Date: 2007-01-24 09:12:43
Message-ID: 729B02C7-87D1-4C69-A171-22483668D83A@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)rupp(at)redhat(dot)com, http://www.dpunkt.de/buch/3-89864-429-4.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shoaib Mir 2007-01-24 10:19:22 Re: slow result
Previous Message Richard Huxton 2007-01-24 08:54:05 Re: Auto Vacuum Problem