Re: updates (postgreSQL) very slow

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: updates (postgreSQL) very slow
Дата
Msg-id Pine.LNX.4.33.0403101015540.10418-100000@css120.ihs.com
обсуждение исходный текст
Ответ на updates (postgreSQL) very slow  ("Bobbie van der Westhuizen" <Bobbie@irene.agric.za>)
Список pgsql-general
Дерево обсуждения 
Have you run this update query again and again with vacuuming?

http://www.postgresql.org/docs/7.4/static/maintenance.html#ROUTINE-VACUUMING

If so, you might have millions and millions of dead tuples taking up
space and slowing things down.  If you're running 7.4, install the
autovacuum daemon and turn it on.  Nice little program that should mostly
take care of this issue for you.

Got any foreign keys on that field?  Triggers?

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

Предыдущее
От: Frank van Vugt
Дата:
Сообщение: Re: does this look more like a possible bug or more like a possible hardware problem...? (long)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: does this look more like a possible bug or more like a possible hardware problem...? (long)