Re: How to fast the REINDEX

От: Brad Nicholson
Тема: Re: How to fast the REINDEX
Дата: ,
Msg-id: 1270129975.5155.317.camel@bnicholson-desktop
(см: обсуждение, исходный текст)
Ответ на: Re: How to fast the REINDEX  (raghavendra t)
Список: pgsql-performance

Скрыть дерево обсуждения

How to fast the REINDEX  (raghavendra t, )
 Re: How to fast the REINDEX  ("Kevin Grittner", )
  Re: How to fast the REINDEX  (raghavendra t, )
   Re: How to fast the REINDEX  ("Kevin Grittner", )
    Re: How to fast the REINDEX  (raghavendra t, )
     Re: How to fast the REINDEX  ("Kevin Grittner", )
      Re: How to fast the REINDEX  (raghavendra t, )
       Re: How to fast the REINDEX  ("Kevin Grittner", )
        Re: How to fast the REINDEX  (raghavendra t, )
         Re: How to fast the REINDEX  (Hannu Krosing, )
   Re: How to fast the REINDEX  (Jaime Casanova, )
    Re: How to fast the REINDEX  (Craig Ringer, )
     Re: How to fast the REINDEX  (Steve Clark, )
      Re: How to fast the REINDEX  ("Pierre C", )
       Re: How to fast the REINDEX  (raghavendra t, )
        Re: How to fast the REINDEX  (Brad Nicholson, )
        Re: How to fast the REINDEX  ("Kevin Grittner", )
        Re: How to fast the REINDEX  (Robert Haas, )
 Re: How to fast the REINDEX  (Greg Smith, )

On Thu, 2010-04-01 at 19:17 +0530, raghavendra t wrote:
>
> Hi All,
>
> System Config
> ---------------------
> CPU - Intel® Xenon® CPU
> CPU Speed - 3.16 GHz
> Server Model - Sun Fire X4150
> RAM-Size - 16GB
>
>         Steve:
>         So am I to understand I don't need to do daily reindexing as a
>         maintenance measure with 8.3.7 on FreeBSD.
>
> My question is something like Steve's, why we should not do reindexing
> as our maintenance task. I was doing reindex only to get
> a best fit and not fall short of 90% hole, bcoz my table has lot of
> updates and deletes. We also has the weekly maintance of VACUUM, but
> still reindex takes lot of time.

This is your problem.  You should enable autovaccuum, let the vacuums
happen more frequently, and this problem will go away.  You will still
have to fix the underlying bloat a last time though.


--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




В списке pgsql-performance по дате сообщения:

От: Faheem Mitha
Дата:
Сообщение: Re: experiments in query optimization
От: Scott Carey
Дата:
Сообщение: Re: Database size growing over time and leads to performance impact