Re: How to fast the REINDEX

От: Kevin Grittner
Тема: Re: How to fast the REINDEX
Дата: ,
Msg-id: 4BB3722F02000025000302BF@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: How to fast the REINDEX  (raghavendra t)
Ответы: 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, )

raghavendra t <> wrote:

> I have a table with 40GB size, it has few indexes on it.

What does the table look like?  What indexes are there?

> When i try to REINDEX on the table,

Why are you doing that?

> its take a long time.

How long?

> I tried increasing the maintenance_work_mem, but still i havnt
> find a satisfying result.

What run time are you expecting?

> Questions
> =======
> 1. What are the parameters will effect, when issuing the REINDEX
>    command
> 2. Best possible way to increase the spead of the REINDEX

It's hard to answer that without more information, like PostgreSQL
version and configuration, for starters.  See:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

My best guess is that you can make them instantaneous by not running
them.  A good VACUUM policy should make such runs unnecessary in
most cases -- at least on recent PostgreSQL versions.

-Kevin


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

От: Bruce Momjian
Дата:
Сообщение: Re: temp table "on commit delete rows": transaction overhead
От: Craig Ringer
Дата:
Сообщение: Re: How to fast the REINDEX