Re: Delete performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete performance
Дата
Msg-id 19710.1005865269@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Delete performance  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
Список pgsql-general
"P.J. \"Josh\" Rovero" <rovero@sonalysts.com> writes:
> Is there a performance issue deleting rows of a table where one
> field is toasted text?

It'd require an additional table access for each such field, but
that seems unlikely to explain the performance problem you're seeing.
Have you looked at EXPLAIN output for the two cases?

            regards, tom lane

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

Предыдущее
От: "Culley Harrelson"
Дата:
Сообщение: [PHP] Re: psql with PHP question
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Bug?