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

Поиск
Список
Период
Сортировка
От Rini Dutta
Тема Re: drastic reduction in speed of inserts as the table grows
Дата
Msg-id 20010417153211.20493.qmail@web12502.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: drastic reduction in speed of inserts as the table grows  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: drastic reduction in speed of inserts as the table grows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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

I'll try it out. Just for my understanding, is the
'lots-of-pending-triggers' problem related to indexes,
or to foreign keys ?

Rini

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

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

Предыдущее
От: will trillich
Дата:
Сообщение: Re: bpchar type
Следующее
От: will trillich
Дата:
Сообщение: Re: Problem with function invocation