Re: PostgreSQL reclaiming table space
| От | Anthony Bull |
|---|---|
| Тема | Re: PostgreSQL reclaiming table space |
| Дата | |
| Msg-id | CAGK=A1kUMZDi+=rSZj57qjn7y7KuZy=bth9n1761Bd8OED_aJQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL reclaiming table space (Jens Wilke <jens@wilke.org>) |
| Ответы |
Re: PostgreSQL reclaiming table space
|
| Список | pgsql-general |
I did not run analyze, only vacuum full - the disk usage reported by the OS has stayed the same also - the data folder under postgres is still at over 25GB. Postgres itself also still reports db size at 25GB, but when I ask postgres for a table breakdown by size, it reports only about 9GB of tables in the db.
Will analyze help? I was under the impression that was more for statistics gathering and index optimising?
On Mon, May 28, 2012 at 11:16 PM, Jens Wilke <jens@wilke.org> wrote:
On Montag, 28. Mai 2012, Anthony Bull wrote:
Hi,Did you run analyze?
>This did not
> work either - postgres still reports 25GB being used by the
> database.
Did the disk usage reported by the OS shrink?
Regards, Jens
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: