Re: Too much time to delete 19000 rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Too much time to delete 19000 rows
Дата
Msg-id 4246.1160159241@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Too much time to delete 19000 rows  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Список pgsql-sql
"Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> writes:
> The selection takes less than 1 second but on delete I wait more than 4
> minutes and notthing. Can someone tell me what could happen ?

Perhaps foreign keys referencing this table and no indexes on the
referencing columns?  You're not required to have an index on the
referencing side, but you pay for it when you update or delete in
the master table...
        regards, tom lane


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Too much time to delete 19000 rows
Следующее
От: Kyle Bateman
Дата:
Сообщение: PG 8.2beta reordering working for this case?