| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Trujillo | 2001-11-29 16:08:40 | Re: table test |
| Previous Message | Eric Johnson | 2001-11-29 15:20:09 | Re: table test |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giuseppe Tanzilli - CSF | 2001-11-29 16:25:06 | select NOT IN with NULL bug on 7.2b3 |
| Previous Message | Peter Eisentraut | 2001-11-29 16:05:06 | Re: Call for platform testing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-11-29 16:36:20 | Re: Where do I start |
| Previous Message | Tom Lane | 2001-11-29 15:06:10 | Re: [HACKERS] upper and lower doesn't work with german |