From: | Alexander Schöcke <asc(at)turtle-entertainment(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Bloated Table |
Date: | 2009-05-27 13:51:14 |
Message-ID: | 4F1490B538ECAC4BA98D23915717B82D0105149F@winexch1.office.turtle-entertainment.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everybody.
I'm using a view (http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html) to display the bloat (unused disk space) of the tables in a PostgreSQL database. Using this data I want to implement a database maintenance script automatically exectuting a VACUUM FULL on these tables.
Unfortunately I am finding a table to have bloat which can't be reclaimed. I have tried VACUUM, REINDEX, VACUUM FULL ANALYZE with REINDEX, and even dump and restore. The view always shows 375MB of bloat for the table.
Is this normal? Here's the table structure:
Table "public.foobar_log"
Column | Type | Modifiers
------------+--------------------------+-----------------------------------------------------------
foorbarid | integer | not null default nextval('foobar_log_id_seq'::regclass)
created_at | timestamp with time zone | not null
foo | character varying(50) | not null
bar | character varying(16) | not null
chit | integer | not null
chat | boolean | not null default false
Indexes:
"bar_index" btree (bar)
"foobarid_foobar_log_key" btree (foobarid)
"chit_foobar_log_key" btree (chit)
The table consists of approximately 2.4 million entries.
Any help is appreciated.
Kind regards, Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2009-05-27 13:58:04 | Re: Regular expression and array |
Previous Message | Csaba Nagy | 2009-05-27 12:57:37 | Re: a strange error |