Re: How do I know my table is bloated?

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How do I know my table is bloated?
Date: 2013-05-30 14:16:37
Message-ID: A76B25F2823E954C9E45E32FA49D70EC1B7E4EFE@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Rodrigo Barboza
Sent: Thursday, May 30, 2013 9:06 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] How do I know my table is bloated?

Hi, everyone.
I saw some people talking about the reindex command and I read in the docs the one reason to use reindex is when a table is bloated.
But how do I know when a table is bloated?

You could use PGSTATTUPLE extension, which you could read about here:

http://www.postgresql.org/docs/9.2/static/pgstattuple.html

Regards,
Igor Neyman

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rodrigo Barboza 2013-05-30 14:42:22 Re: How do I know my table is bloated?
Previous Message Rodrigo Barboza 2013-05-30 13:05:57 How do I know my table is bloated?