Re: [GENERAL] Strange case of database bloat - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] Strange case of database bloat
Date
Msg-id CAMkU=1wLggpgtb4=kve4G6zpMCKiiF=TLBAFd1WyTrL8QhKPtg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Strange case of database bloat  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
On Tue, Jul 4, 2017 at 10:18 PM, Chris Travers <chris.travers@gmail.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

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Re: [GENERAL] Feature proposal, DBURL: psql pgsql://joe:p4zzw0rd@example.org:2345/dbname
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot