From: | Jenish <jenishvyas(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Performance issue with Insert |
Date: | 2011-06-27 15:01:37 |
Message-ID: | BANLkTimPHiOSAqyHX2_NdQCOtg2Zh2fZnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(dot)Grittner(at)wicourts(dot)gov
> wrote:
> Jenish <jenishvyas(at)gmail(dot)com> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Mantheakis | 2011-06-27 15:02:02 | Re: Long Running Update - My Solution |
Previous Message | Kevin Grittner | 2011-06-27 14:37:53 | Re: Performance issue with Insert |