| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Neuber, Dirk" <dirk(dot)neuber(at)barco(dot)com> |
| Cc: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>, "Henry, Frank" <frank(dot)henry(at)barco(dot)com>, pgsql-admin(at)postgresql(dot)org, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Subject: | Re: Large files in main/base |
| Date: | 2010-07-11 15:51:00 |
| Message-ID: | 19574.1278863460@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Neuber, Dirk" <dirk(dot)neuber(at)barco(dot)com> writes:
> One last question. After using vacuumlo the file size of 16385/2613 is
> still the same as before.
> It seems the content has been removed but the file itself hasn't been
> compacted.
> Is there an option or tool which can do this as well ?
Yeah, you still need to apply VACUUM FULL to bring the physical file
size down. (Ordinary VACUUM mostly just recycles space within the
file --- it can truncate the file if the end pages are empty, but
it won't move data around to make that possible.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ascarabina | 2010-07-11 20:28:58 | |
| Previous Message | Neuber, Dirk | 2010-07-11 12:58:14 | Re: Large files in main/base |