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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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

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-2017 The PostgreSQL Global Development Group