Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D5834B5DBC4 for ; Mon, 27 Jun 2011 17:14:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 35786-03 for ; Mon, 27 Jun 2011 20:14:41 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 849D2B5D803 for ; Mon, 27 Jun 2011 17:14:41 -0300 (ADT) Received: by iwn6 with SMTP id 6so4388109iwn.19 for ; Mon, 27 Jun 2011 13:14:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=V99WY9en5acttNbWFYjofZbKdBgB9LnsSZ6f7N8Eqi8=; b=Q9/9D689eScG/n/eEzoBjXrpVc4TmoNc9U8pjw9b4FkpS8LzK+oiaBN9dOz6lPB+Jo JMg5isM8ohDirZGNYqK69Dv5MWuA5FPx+2Hi0lZUEqkeN+sEG9rmBkR7jbOiWNBL+qXk LS557OmEKfbwvUHpnAyMf5TkXMFYFldkqITqA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=gH34LQl8x/+HEW/BVlR+K9OJBe6Q2SL+Z45O+sWTvax9xtImUMcjnV2oUihyL6FA3M gOWxYBojSgSQll8TQ+pkd4u4JppYVDwwoVwKhsW9/x0K+PA5MHTGOsYZolufUARNMENA ntniKTEsi8ENtG2yZ4NGJ1Y4HjCUownIRg1ao= MIME-Version: 1.0 Received: by 10.42.168.137 with SMTP id w9mr4827319icy.121.1309205680042; Mon, 27 Jun 2011 13:14:40 -0700 (PDT) Received: by 10.231.30.73 with HTTP; Mon, 27 Jun 2011 13:14:39 -0700 (PDT) In-Reply-To: <4E08DE81.4040100@fuzzy.cz> References: <4E084F71020000250003EC59@gw.wicourts.gov> <4E08DE81.4040100@fuzzy.cz> Date: Mon, 27 Jun 2011 23:14:39 +0300 Message-ID: Subject: Re: Performance issue with Insert From: Jenish To: Tomas Vondra Cc: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=90e6ba6e8cd47f343c04a6b733a7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201106/253 X-Sequence-Number: 44186 --90e6ba6e8cd47f343c04a6b733a7 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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=92t know whether it is the same session or different session. DB id huge but Triggers are not touching the whole database. I=92ll provide the result set of vmstat and iostat tomorrow. --=20 Thanks & regards, JENISH VYAS On Mon, Jun 27, 2011 at 10:48 PM, Tomas Vondra 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 > --90e6ba6e8cd47f343c04a6b733a7 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi ,

This server is the dedicated database server.

=A0And I am testing th= e limit for the concurrent active users. When I am running my test for 400 concurre= nt user ie. Active connection. I am getting good performance but when I am run= ning the same the same test for 950 concurrent users I am getting very bad performance.

=A0

>> Scenario : =A0All inser= t are waiting for previous insert to complete.

I don=92t know whether it is the same session = or different session.

=A0

DB id huge but Triggers are not touching the w= hole database.

I=92ll provide the result set of vmstat and io= stat tomorrow.


--=A0
Thank= s & regards,
JENISH VYAS

=A0


O= n 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 =A0: Debian
> HD : SAS 10k rpm
>
> Shared_buffer is 4096 25 % of RAM , effective_cache is 8GB 75% of RAM<= br>
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




--90e6ba6e8cd47f343c04a6b733a7--