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@wicourts.gov> wrote:
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