Re: Performance issue with Insert

[Jenish <jenishvyas@xxxxxxxxx>]

Hi,

DB : POSTGRES 8.4.8

OS  : Debian

HD : SAS 10k rpm

Shared_buffer is 4096 25 % of RAM , effective_cache is 8GB 75% of RAM

After insert trigger is again calling 2 more trigger and insert record in another table depends on condition.

with all trigger enable there are 8 insert and 32 updates(approx. update is depends on hierarchy)

Plz explain multiple connections. Current scenario application server is sending all requests.

-- 
Thanks & regards,
JENISH VYAS

On Mon, Jun 27, 2011 at 5:37 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:

Jenish <jenishvyas@xxxxxxxxx> wrote:

> I am using postgres 8.4.x

With x being what?  On what OS and hardware?

> 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.

http://wiki.postgresql.org/wiki/SlowQueryQuestions

> After insert trigger is recursive trigger.

So are you counting only the top level inserts or also the ones
generated by the recursive inserts?

> My question.
>
> How to avoid the bottleneck?

First you need to find out what the bottleneck is.

> Parallel processing is possible in Postgres? How?

To achieve parallel processing in PostgreSQL you need to use
multiple connections.

-Kevin