Performance issue with Insert

Поиск
Список
Период
Сортировка
От Jenish
Тема Performance issue with Insert
Дата
Msg-id BANLkTik3DzYsBTbryAwp0=cqwG_uadR72g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Performance issue with Insert  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Performance issue with Insert  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Hi All,

I am facing some performance issue with insert into some table.

I am using postgres 8.4.x

Table is having 3 before insert trigger and one after insert trigger.

With all triggers enable it is inserting only 4-5 record per second.

But if I disable after insert trigger it is able to insert 667 records per second.

After insert trigger is recursive trigger.


My question.

How to avoid the bottleneck?

Parallel processing is possible in Postgres? How?


Please give you suggestion.  
--
Thanks & regards,
JENISH VYAS


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

Предыдущее
От: Jens Hoffrichter
Дата:
Сообщение: Getting rid of a seq scan in query on a large table
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Getting rid of a seq scan in query on a large table