Re: json datatype and table bloat?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: json datatype and table bloat?
Date: 2013-10-29 19:49:10
Message-ID: 52701136.307@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/29/2013 12:41 PM, Gregory Haase wrote:
> db_name=# VACUUM FULL VERBOSE table_schema.table_name;
> INFO: vacuuming "table_schema.table_name"
> INFO: "table_name": found 2 removable, 29663 nonremovable row
> versions in 1754 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU 0.07s/0.10u sec elapsed 0.30 sec.

is there an old transaction pending? that 'masks' vacuum from touching
any tuples newer than the start of that transaction.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Haase 2013-10-29 19:53:49 Re: json datatype and table bloat?
Previous Message Gregory Haase 2013-10-29 19:41:18 Re: json datatype and table bloat?