Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id 1112005263.11750.886.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Delete query takes exorbitant amount of time  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-performance
On Sun, 2005-03-27 at 07:05 -0800, Stephan Szabo wrote:
> On Sat, 26 Mar 2005, Karim Nassar wrote:
> > Some improvement. Even better once it's cached. Row estimate didn't
> > change. Is this the best I can expect? Is there any other optimizations
> > I am missing?
>
> I'm not sure, really. Running a seq scan for each removed row in the
> referenced table doesn't seem like a particularly good plan in general
> though, especially if the average number of rows being referenced isn't
> on the order of 500k per value. I don't know what to look at next though.
>

Karim, please...

run the EXPLAIN after doing
    SET enable_seqscan = off

Thanks,

Best Regards, Simon Riggs


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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: What about utility to calculate planner cost constants?
Следующее
От: Rudi Starcevic
Дата:
Сообщение: NFS RAID 0/5