Re: Impossibly slow DELETEs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Impossibly slow DELETEs
Дата
Msg-id 9857.1069807038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Impossibly slow DELETEs  (Neil Conway <neilc@samurai.com>)
Список pgsql-performance
Neil Conway <neilc@samurai.com> writes:
>> There are 6 rows in the table (given that size, I assumed that an
>> index was not necessary).

> That's a reasonable assumption.

But if he's updated those rows a few hundred thousand times and never
VACUUMed, he could be having some problems ...

            regards, tom lane

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Impossibly slow DELETEs
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Optimize