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

Vacuum

From: bangh <banghe(at)baileylink(dot)net>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum
Date: 2001-11-29 16:06:02
Message-ID: 3C065CEA.B23D9745@baileylink.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-novice
Hello,

Using vacuum a table is very usefull to compress the space of a table .
However I noticed the index grows also very fast. Does anyone have a way to
compress the index? I know if I dump the  database, and destroy the orginal
database, then create new one using the same database, and restory the dump
file, that will dramatically compress the space the database has taken. This
is not a good way for a live database that is driven by the web application
that means I have to shut down the web application service during this
clearup.

Thanks,

Bangh


In response to

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2001-11-29 16:36:20
Subject: Re: Where do I start
Previous:From: Tom LaneDate: 2001-11-29 15:06:10
Subject: Re: [HACKERS] upper and lower doesn't work with german

pgsql-hackers by date

Next:From: Giuseppe Tanzilli - CSFDate: 2001-11-29 16:25:06
Subject: select NOT IN with NULL bug on 7.2b3
Previous:From: Peter EisentrautDate: 2001-11-29 16:05:06
Subject: Re: Call for platform testing

pgsql-admin by date

Next:From: Manuel TrujilloDate: 2001-11-29 16:08:40
Subject: Re: table test
Previous:From: Eric JohnsonDate: 2001-11-29 15:20:09
Subject: Re: table test

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