how fast index works?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: how fast index works?
Date: 2011-09-06 18:31:33
Message-ID: 001501cc6cc3$3649a3c0$a2dceb40$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Hodgson 2011-09-06 19:07:56 Re: Rather large LA
Previous Message Tomas Vondra 2011-09-06 16:50:19 Re: Sudden drop in DBb performance