Re: Strange case of database bloat

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Chris Travers <chris(dot)travers(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange case of database bloat
Date: 2017-07-05 15:45:45
Message-ID: CAMkU=1wLggpgtb4=kve4G6zpMCKiiF=TLBAFd1WyTrL8QhKPtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 4, 2017 at 10:18 PM, Chris Travers <chris(dot)travers(at)gmail(dot)com>
wrote:

>
> Questions
> ===========
> I assume that it is the fact that rows update frequently which is the
> problem here? But why doesn't Postgres re-use any of the empty disk pages?
>

Can you install the contrib extension pg_freespacemap and use "select *
from pg_freespace('table_name')" to see if PostgreSQL agrees that the space
is re-usable?

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-07-05 15:46:26 Re: pg_start/stop_backup non-exclusive scripts to snapshot
Previous Message Hans Schou 2017-07-05 15:31:51 Re: Feature proposal, DBURL: psql pgsql://joe:p4zzw0rd@example.org:2345/dbname