Re: Waiting for Update

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Waiting for Update
Дата
Msg-id 3D2C524E.24277DFC@Yahoo.com
обсуждение исходный текст
Ответ на Waiting for Update  (JGM <jgmischke@j-g-m.de>)
Список pgsql-sql
JGM wrote:
> 
> Could it be true??
> 
> I've a table with < 46000 rows. And a little Update like
> 
> UPDATE foo set xxx = 'X';
> 
> needs about 15 seconds???
> 
> What's wrong?

How long since you vacuumed that table? How big are the rows? Are there
triggers, constraints, anything fancy? How many indexes does foo have?


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: Error with DISTINCT and AS keywords
Следующее
От: Jie Liang
Дата:
Сообщение: Re: pg_restore cannot restore index