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 14:54:40
Message-ID: 4F1490B538ECAC4BA98D23915717B82D010514C9@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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo Franco 2009-05-27 15:00:40 Re: How to Install Postgres 8.3 in Solaris 10 as a service
Previous Message Grzegorz Jaśkiewicz 2009-05-27 14:39:40 Re: composite type and domain