Re: Zero dead tuples, when significant apparent bloat

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Melesky <john(dot)melesky(at)rentrakmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Zero dead tuples, when significant apparent bloat
Date: 2013-12-11 02:05:42
Message-ID: 16326.1386727542@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Melesky <john(dot)melesky(at)rentrakmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-12-11 03:22:57 Re: [Postgres-xc-general] "Tuple not found error" during Index creation
Previous Message bricklen 2013-12-11 01:57:24 Re: Zero dead tuples, when significant apparent bloat