Postgres Pro
Downloads
Home   >   mailing lists

Re: Zero dead tuples, when significant apparent bloat - Mailing list pgsql-general

From Tom Lane
Subject Re: Zero dead tuples, when significant apparent bloat
Date
Msg-id 16326.1386727542@sss.pgh.pa.us
Whole thread Raw
In response to Zero dead tuples, when significant apparent bloat  (John Melesky <john.melesky@rentrakmail.com>)
List pgsql-general
Tree view 
John Melesky <john.melesky@rentrakmail.com> writes:
> It seems clear that there were dead tuples, since the table size shrank to
> an eighth of its previous size. Why did analyze not pick that up?

Dead tuples and empty space are not the same thing.

            regards, tom lane

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: Zero dead tuples, when significant apparent bloat
Next
From: Michael Paquier
Date:
Subject: Re: [Postgres-xc-general] "Tuple not found error" during Index creation