Re: drastic reduction in speed of inserts as the table grows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: drastic reduction in speed of inserts as the table grows
Дата
Msg-id 23874.987521637@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
Список pgsql-general
Rini Dutta <rinid@rocketmail.com> writes:
> I'll try it out. Just for my understanding, is the
> 'lots-of-pending-triggers' problem related to indexes,
> or to foreign keys ?

Foreign keys.  Does your speed problem go away if the table being
inserted into has no foreign keys?

            regards, tom lane

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

Предыдущее
От: Christian Fritze
Дата:
Сообщение: Re: index not used with subselect in where clause ?
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: View and function