Re: Performance degredation at client site

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Performance degredation at client site
Дата
Msg-id opslhbmydnth1vuj@musicbox
обсуждение исходный текст
Ответ на Performance degredation at client site  (Bill Chandler <billybobc1210@yahoo.com>)
Список pgsql-performance
> Do I understand correctly, however, that when you
> create a unique SERIAL column an index is
> automatically created on that column?  If so, does
> that sound like a possible culprit?  We are not doing
> any reindexing on that index at all.  Could it be
> suffering from index bloat?  Do we need to
> periodically explicity run the command:

    SERIAL creates a sequence, not an index.
    UNIQUE and PRIMARY KEY do create indexes.


    Regards.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance degredation at client site
Следующее
От: Bill Chandler
Дата:
Сообщение: Re: Performance degredation at client site