Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 352EAB5DBC4 for ; Tue, 6 Sep 2011 15:58:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 82532-07 for ; Tue, 6 Sep 2011 18:58:53 +0000 (UTC) X-Greylist: delayed 00:27:40.909807 by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id E57CCB5DBBE for ; Tue, 6 Sep 2011 15:58:52 -0300 (ADT) Received: by gwaa12 with SMTP id a12so3737634gwa.19 for ; Tue, 06 Sep 2011 11:58:52 -0700 (PDT) Received: by 10.91.93.2 with SMTP id v2mr3939916agl.100.1315333871381; Tue, 06 Sep 2011 11:31:11 -0700 (PDT) Received: from AnibalVAIO ([200.85.32.68]) by mx.google.com with ESMTPS id c15sm1023206anm.3.2011.09.06.11.31.06 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 06 Sep 2011 11:31:08 -0700 (PDT) From: "Anibal David Acosta" To: Subject: how fast index works? Date: Tue, 6 Sep 2011 14:31:33 -0400 Message-ID: <001501cc6cc3$3649a3c0$a2dceb40$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01CC6CA1.AF38EE20" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcxswSuliKz++YSlSPqvInr3MN13SQ== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201109/64 X-Sequence-Number: 44840 This is a multipart message in MIME format. ------=_NextPart_000_0016_01CC6CA1.AF38EE20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi everyone, My question is, if I have a table with 500,000 rows, and a SELECT of one row is returned in 10 milliseconds, if the table has 6,000,000 of rows and everything is OK (statistics, vacuum etc) can i suppose that elapsed time will be near to 10? ------=_NextPart_000_0016_01CC6CA1.AF38EE20 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi = everyone,

My question is, if I have a table with 500,000 rows, = and a SELECT of one row is returned in 10 milliseconds, if the table has = 6,000,000 of rows and everything is OK (statistics, vacuum etc) =

can i suppose that elapsed time will = be near to 10?

------=_NextPart_000_0016_01CC6CA1.AF38EE20--