From: Jenish <jenishvyas@gmail.com>
To: Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance issue with Insert
Date: Mon, 27 Jun 2011 23:14:39 +0300
Message-ID: <BANLkTimXN_QitBoaVTfEPe503Ah+e3F=zw@mail.gmail.com> (raw)
In-Reply-To: <4E08DE81.4040100@fuzzy.cz>
References: <BANLkTik3DzYsBTbryAwp0=cqwG_uadR72g@mail.gmail.com>
<4E084F71020000250003EC59@gw.wicourts.gov>
<BANLkTimPHiOSAqyHX2_NdQCOtg2Zh2fZnA@mail.gmail.com>
<4E08DE81.4040100@fuzzy.cz>
Hi ,
This server is the dedicated database server.
And I am testing the limit for the concurrent active users. When I am
running my test for 400 concurrent user ie. Active connection. I am getting
good performance but when I am running the same the same test for 950
concurrent users I am getting very bad performance.
>> Scenario : All insert are waiting for previous insert to complete.
I don’t know whether it is the same session or different session.
DB id huge but Triggers are not touching the whole database.
I’ll provide the result set of vmstat and iostat tomorrow.
--
Thanks & regards,
JENISH VYAS
On Mon, Jun 27, 2011 at 10:48 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
> Dne 27.6.2011 17:01, Jenish napsal(a):
> > 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
>
> How much data are we talking about? Does that fit into the shared
> buffers or is it significantly larger? Do the triggers touch the whole
> database or just a small part of it (active part)?
>
> regards
> Tomas
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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, tv@fuzzy.cz
Subject: Re: Performance issue with Insert
In-Reply-To: <BANLkTimXN_QitBoaVTfEPe503Ah+e3F=zw@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