Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Shoaib MirDate: 2007-01-24 10:19:22
Subject: Re: slow result
Previous:From: Richard HuxtonDate: 2007-01-24 08:54:05
Subject: Re: Auto Vacuum Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group