Re: DELETE running at snail-speed

Поиск
Список
Период
Сортировка
От gerhard
Тема Re: DELETE running at snail-speed
Дата
Msg-id 671a3c56-a1c4-423a-a081-9dc30e84583d@40g2000prx.googlegroups.com
обсуждение исходный текст
Ответ на DELETE running at snail-speed  (gerhard <g.hintermayer@inode.at>)
Список pgsql-general
Added indices on the two tables that used foreign keys to the delting
table, and voila - delete finishes fast.
Thanks for the tip, also using explain analyze, as someone else
pointed out, would have shown me, where the problem comes from.

Thanks everybody for helping.
Gerhard


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

Предыдущее
От: gerhard
Дата:
Сообщение: Re: DELETE running at snail-speed
Следующее
От: "George Weaver"
Дата:
Сообщение: Server side large object functions