From: Jenish <jenishvyas@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance issue with Insert
Date: Mon, 27 Jun 2011 18:01:37 +0300
Message-ID: <BANLkTimPHiOSAqyHX2_NdQCOtg2Zh2fZnA@mail.gmail.com> (raw)
In-Reply-To: <4E084F71020000250003EC59@gw.wicourts.gov>
References: <BANLkTik3DzYsBTbryAwp0=cqwG_uadR72g@mail.gmail.com>
<4E084F71020000250003EC59@gw.wicourts.gov>
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:
> Jenish <jenishvyas@gmail.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jenishvyas@gmail.com, Kevin.Grittner@wicourts.gov
Subject: Re: Performance issue with Insert
In-Reply-To: <BANLkTimPHiOSAqyHX2_NdQCOtg2Zh2fZnA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox