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 23801.987520882@sss.pgh.pa.us
обсуждение исходный текст
Ответ на drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
Ответы Re: drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
Another qs Re: drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
Список pgsql-general
Rini Dutta <rinid@rocketmail.com> writes:
> Here is the performance statistics on the same table.
> Note the fall in performance as the test proceeds.

Try 7.1.  I think you are running into the lots-of-pending-triggers
problem that was found and fixed awhile back.

            regards, tom lane

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

Предыдущее
От: "Rod Taylor"
Дата:
Сообщение: Re: index not used with subselect in where clause ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: failed sanity check, table answers was not found