Bloated Table

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

Browse pgsql-general by date

  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