Re: deletions on master table takes for ever...

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: deletions on master table takes for ever...
Дата
Msg-id 20020413075506.W84263-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на deletions on master table takes for ever...  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-sql
On Sat, 13 Apr 2002, Rajesh Kumar Mallah wrote:

> Also i would like to tell that the are 8 tables linked to the master
> table
> email_bank so every deletetion on email_bank is eight deletions.
>
> do i need to create indexes on the slave tables also ?

You probably should since otherwise it's going to need to do sequential
scans of all those tables for each row being deleted.  That may or may not
be the bottleneck here, but it's worth doing.




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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: deletions on master table takes for ever...
Следующее
От: "postgresql"
Дата:
Сообщение: to_char problem