Skip site navigation (1) Skip section navigation (2)

Performance issue with Insert

From: Jenish <jenishvyas(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance issue with Insert
Date: 2011-06-27 14:22:58
Message-ID: BANLkTik3DzYsBTbryAwp0=cqwG_uadR72g@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-06-27 14:30:23
Subject: Re: Getting rid of a seq scan in query on a large table
Previous:From: Jens HoffrichterDate: 2011-06-27 12:46:46
Subject: Getting rid of a seq scan in query on a large table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group