Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2C109B5DBE0 for ; Thu, 8 Sep 2011 09:56:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 09551-08 for ; Thu, 8 Sep 2011 12:56:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id CEB68B5DBDA for ; Thu, 8 Sep 2011 09:56:49 -0300 (ADT) Received: by yxp4 with SMTP id 4so424573yxp.19 for ; Thu, 08 Sep 2011 05:56:49 -0700 (PDT) Received: by 10.236.22.33 with SMTP id s21mr4037545yhs.70.1315486254032; Thu, 08 Sep 2011 05:50:54 -0700 (PDT) Received: from AnibalVAIO ([200.85.32.68]) by mx.google.com with ESMTPS id u13sm779404anf.14.2011.09.08.05.50.46 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 08 Sep 2011 05:50:50 -0700 (PDT) From: "Anibal David Acosta" To: Subject: how delete/insert/update affects select performace? Date: Thu, 8 Sep 2011 08:51:13 -0400 Message-ID: <004301cc6e26$015a75e0$040f61a0$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0044_01CC6E04.7A497220" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcxuJfxC66VLuGn/QpO99fVSw14MYQ== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.584 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, SARE_MILLIONSOF=0.315 X-Spam-Level: X-Archive-Number: 201109/75 X-Sequence-Number: 44851 This is a multipart message in MIME format. ------=_NextPart_000_0044_01CC6E04.7A497220 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi! I have a table not too big but with aprox. 5 millions of rows, this table must have 300 to 400 select per second. But also must have 10~20 delete/insert/update per second. So, I need to know if the insert/delete/update really affect the select performance and how to deal with it. The table structure is very simple: account_id integer (PK) service_id integer (PK) enabled char(1) The index created on this has the same 3 columns. Most of time the table has more insert or delete than update, when update occur the column changed is enabled; Thanks! ------=_NextPart_000_0044_01CC6E04.7A497220 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi!

 

I have a = table not too big but with aprox. 5 millions of rows, this table must = have 300 to 400 select per second. But also must have 10~20 = delete/insert/update per second.

 

So, I need = to know if the insert/delete/update really affect the select performance = and how to deal with it.

 

The table = structure is very simple:

 

account_id = integer (PK)

service_id integer = (PK)

enabled char(1)

 

The index = created on this has the same 3 columns.

 

Most of time = the table has more insert or delete than update, when update occur the = column changed is enabled;

 

Thanks!

 

 

------=_NextPart_000_0044_01CC6E04.7A497220--