relpages sudden increase

From: Richard Harley <raharley0(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: relpages sudden increase
Date: 2012-05-08 17:27:16
Message-ID: 4FA95774.40405@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I currently do nightly database dumps on a ton of small dbs that are
increasing around 2-3mb per day. Suddenly, in a recent backup file, one
db in particular jumped from 55mb to 122mb overnight.

I did some investigation -

One table increased from 8mb to 31mb during a 24hr period. The table is
just text so this is highly unusual given that the number of rows DIDN'T
increase any more than normal.

pg_toast increased from 8mb to 27mb during the same period.

The relpages for the table in question increased from 164 to 1088 during
the 24hr period. On the live db, the relpages is back to 164 but the
size of the table remains massive.

Using Centos5/postgres 8.1.21 at the moment. Planning to upgrade over
summer but not had issues like this before on 8.1.

What gives?!

Thanks
Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Goméz Soto 2012-05-08 18:32:23 Re: 2 machines, same database, same query, 10 times slower?
Previous Message Rebecca Clarke 2012-05-08 16:16:44 Re: .pgpass not working