Re: Slow update

Список
Период
Сортировка
От Tom Lane
Тема Re: Slow update
Дата
Msg-id 21383.1113320438@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Slow update  (Bendik R.Johansen)
Список pgsql-performance
Дерево обсуждения
Slow update  (Bendik R.Johansen, )
 Re: Slow update  (Tom Lane, )
  Re: Slow update  (Bendik R.Johansen, )
   Re: Slow update  (Tom Lane, )
    Re: Slow update  (Bendik R.Johansen, )
     Re: Slow update  (Tom Lane, )
"Bendik R. Johansen" <> writes:
> Yes, I tried dropping it but it did not make a difference.
> Could the table be corrupt or something?

You didn't directly answer the question about whether there were foreign
keys leading to this table.  Checking foreign keys could be the problem,
particularly if the referencing columns don't have indexes.

Also, maybe the table is just bloated?  What does VACUUM VERBOSE say
about it?

            regards, tom lane

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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: performance hit for replication
Следующее
От: Slavisa Garic
Дата:
Сообщение: Many connections lingering