how fast index works?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-performance@xxxxxxxxxxxxxx>
Subject: how fast index works?
From: "Anibal David Acosta" <aa@xxxxxxxxxxxx>
Date: Tue, 6 Sep 2011 14:31:33 -0400
Thread-index: AcxswSuliKz++YSlSPqvInr3MN13SQ==

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?

Follow-Ups:
- Re: how fast index works?
  - From: Merlin Moncure
- Re: how fast index works?
  - From: Craig Ringer
- Re: how fast index works?
  - From: Craig James

Prev by Date: Re: Sudden drop in DBb performance
Next by Date: Re: Rather large LA
Previous by thread: Rather large LA
Next by thread: Re: how fast index works?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux