| From: | Jeff Davis <list-pgsql-general(at)dynworks(dot)com> |
|---|---|
| To: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] PostgreSQL v7.2b2 Released |
| Date: | 2001-11-08 19:15:38 |
| Message-ID: | 200111081918.LAA16826@smtp.ucsd.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general pgsql-hackers |
> What does VACUUM do if it doesn´t shrink the size of the database?
>
I was wondering the same thing, so I looked at the development docs and it
appears that regular VACUUM frees the dead tuples so that the space on a page
may be reused. This approach doesn't actually reduce the number of pages
allocated though, it reduces the chances that more pages will be allocated
(because the pages have free space to make tuples in). VACUUM FULL packs all
the tuples together and actually reduces the number of allocated pages. You
should be able to run a DB 24x7 by issuing only VACUUM without the disk usage
growing out of control.
Jeff Davis
> Saludos... :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-11-09 01:24:42 | Re: [HACKERS] PostgreSQL v7.2b2 Released |
| Previous Message | Marc G. Fournier | 2001-11-08 18:33:15 | Re: OT?: PGReplication project dead? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-11-08 19:18:00 | Re: Problem with function |
| Previous Message | Alvaro Herrera | 2001-11-08 19:13:33 | Re: PSQL anc compile errors |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-11-08 19:30:37 | Re: MD5-based passwords |
| Previous Message | Dave Cramer | 2001-11-08 19:06:21 | Re: MD5-based passwords |