Home > mailing lists

how fast index works? - Mailing list pgsql-performance

From	Anibal David Acosta
Subject	how fast index works?
Date	September 6, 2011 15:58:59
Msg-id	001501cc6cc3$3649a3c0$a2dceb40$@devshock.com Whole thread Raw
Responses	Re: how fast index works? Re: how fast index works? Re: how fast index works?
List	pgsql-performance

Tree view

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?

pgsql-performance by date:

From: "Tomas Vondra"
Date: 06 September 2011, 13:50:28
Subject: Re: Sudden drop in DBb performance

From: Alan Hodgson
Date: 06 September 2011, 16:08:18
Subject: Re: Rather large LA

how fast index works? - Mailing list pgsql-performance

Previous

Next