Re: REINDEX requirement?
| От | Robert Treat |
|---|---|
| Тема | Re: REINDEX requirement? |
| Дата | |
| Msg-id | AANLkTim8qY8qAJSLBz1upCB3=P6bw2UCeFCJ1YBWO8eN@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: REINDEX requirement? ("Igor Neyman" <ineyman@perceptron.com>) |
| Ответы |
Re: REINDEX requirement?
|
| Список | pgsql-general |
On Tue, Nov 9, 2010 at 1:51 PM, Igor Neyman <ineyman@perceptron.com> wrote:
If you are looking for a "poor mans" tool, we have a script that will output numbers on table/index bloat. It's not entirely accurate (patches welcome), but usually good enough to highlight the problems. See http://labs.omniti.com/labs/pgtreats/log/trunk/tools/pg_bloat_report.pl
Robert Treat
play: http://www.xzilla.net
work: http://www.omniti.com/is/hiring
Look at the results of pgstatindex(...) function for specific index.> -----Original Message-----
> From: AI Rumman [mailto:rummandba@gmail.com]
> Sent: Tuesday, November 09, 2010 3:26 AM
> To: pgsql-general General
> Subject: REINDEX requirement?
>
> How do I know that index require REINDEX?
>
>
It's part of pgstattupple contrib module - read it up in the docs.
If you are looking for a "poor mans" tool, we have a script that will output numbers on table/index bloat. It's not entirely accurate (patches welcome), but usually good enough to highlight the problems. See http://labs.omniti.com/labs/pgtreats/log/trunk/tools/pg_bloat_report.pl
Robert Treat
play: http://www.xzilla.net
work: http://www.omniti.com/is/hiring
В списке pgsql-general по дате отправления: