Re: Disk space is consumed by UPDATE query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disk space is consumed by UPDATE query
Дата
Msg-id 9665.1096643199@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Disk space is consumed by UPDATE query  (Patrick Clery <patrick@phpforhire.com>)
Список pgsql-bugs
Дерево обсуждения 
Patrick Clery <patrick@phpforhire.com> writes:
> Here's the query plan:
> ...
>                      ->  Seq Scan on people_locations  (cost=0.00..20.00
> rows=1000 width=122)

The query planner evidently does not know that the people_locations
table is large.  A VACUUM or ANALYZE on it would help a lot.

            regards, tom lane

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