| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: REINDEX requirement? |
| Date: | 2010-11-09 15:08:48 |
| Message-ID: | AANLkTi=UgFfDiZpcrcuwjJQH-vx6_A0ciWzS31J8__vH@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Nov 9, 2010 at 4:26 AM, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> How do I know that index require REINDEX?
Well, the REINDEX page:
<http://www.postgresql.org/docs/current/static/sql-reindex.html>
gives a few examples of why you might need to reindex. I think the
most common reason would probably be due to index bloat. See
<http://wiki.postgresql.org/wiki/Index_Maintenance>
under "Index Bloat" for links to some handy queries to see whether
your tables and/or indexes suffer bloat.
Josh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2010-11-09 15:26:23 | Re: Why facebook used mysql ? |
| Previous Message | Adrian Klaver | 2010-11-09 15:06:06 | Re: Porting from MS Access 2007 to PostgreSQL |