Re: Slow update

Список
Период
Сортировка
От Tom Lane
Тема Re: Slow update
Дата
Msg-id 15725.1113316540@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Slow update  (Bendik R.Johansen)
Ответы 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:
> I am having a bit of trouble updating a single integer column.
> My table has around 10 columns and 260 000 records.

> update no.records set uid = 2;
> (uid is an integer. It has a btree index)

> This update takes more than 20 minutes to execute. Is this normal?

Takes about 20 seconds to update a table of that size on my machine...

What PG version is this?  We used to have some performance issues with
very large numbers of equal keys in btree indexes.  Does dropping the
index make it faster?

Are there foreign keys referencing this table from other tables?

            regards, tom lane

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

Предыдущее
От: "Dave Held"
Дата:
Сообщение: Re: 4 way JOIN using aliases
Следующее
От: Chris Browne
Дата:
Сообщение: Re: performance hit for replication