[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Re-index
From:       Keith <keith () keithf4 ! com>
Date:       2020-11-24 15:09:49
Message-ID: CAHw75vsjnQ10aN=jbTTYECJMtC-vs2XLhx8AoJORpQn_GyS7=g () mail ! gmail ! com
[Download RAW message or body]

On Tue, Nov 24, 2020 at 9:15 AM Bruce Momjian <bruce@momjian.us> wrote:

> On Tue, Nov 24, 2020 at 12:53:42PM +0200, Yambu wrote:
> > Hi
> >
> > How do I check if an index is bloated?
> >
> > Also if i delete a number of records eg 60% of the records in a table ,
> do i
> > need to reindex?
>
> See:
>
>         https://wiki.postgresql.org/wiki/Index_Maintenance
>
> --
>   Bruce Momjian  <bruce@momjian.us>        https://momjian.us
>   EnterpriseDB                             https://enterprisedb.com
>
>   The usefulness of a cup is in its emptiness, Bruce Lee
>
>
>
>
The wiki that Bruce linked is a great resource. I've also written a tool to
better help monitor for table & index bloat

https://github.com/keithf4/pg_bloat_check

Keith

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Tue, Nov 24, 2020 at 9:15 AM Bruce Momjian &lt;<a \
href="mailto:bruce@momjian.us">bruce@momjian.us</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">On Tue, Nov 24, 2020 at 12:53:42PM +0200, Yambu \
wrote:<br> &gt; Hi<br>
&gt; <br>
&gt; How do I check if an index is bloated?<br>
&gt; <br>
&gt; Also if i delete a number of records eg 60% of the records in a table , do i<br>
&gt; need to reindex?<br>
<br>
See:<br>
<br>
            <a href="https://wiki.postgresql.org/wiki/Index_Maintenance" \
rel="noreferrer" target="_blank">https://wiki.postgresql.org/wiki/Index_Maintenance</a><br>
 <br>
-- <br>
   Bruce Momjian   &lt;<a href="mailto:bruce@momjian.us" \
target="_blank">bruce@momjian.us</a>&gt;            <a href="https://momjian.us" \
rel="noreferrer" target="_blank">https://momjian.us</a><br>  EnterpriseDB             \
<a href="https://enterprisedb.com" rel="noreferrer" \
target="_blank">https://enterprisedb.com</a><br> <br>
   The usefulness of a cup is in its emptiness, Bruce Lee<br>
<br>
<br>
<br></blockquote><div><br></div><div>The wiki that Bruce linked is a great resource. \
I&#39;ve also written a tool to better help monitor for table &amp; index \
bloat</div><div><br></div><div><a \
href="https://github.com/keithf4/pg_bloat_check">https://github.com/keithf4/pg_bloat_check</a></div><div><br></div><div>Keith<br> \
</div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]