Re: Performance on very large indexed tables

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance on very large indexed tables
Date: 2002-10-28 14:01:55
Message-ID: 3DBD90AB.28534.DA0C5@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24 Oct 2002 at 17:34, Ingo Schellhammer wrote:
> has anyone experience with very large tables in PostGreSQL?
> I am wondering whether PostGreSQL can handle an indexed table with
> 1.000.000.000 rows and more efficiently?!

Well, on a 4CPU/SCSI RAID machine a query took 250ms to return 150 rows from a
40M rows table. It used index of course..

That's a billion rows right? Shouldn't have a problem..

Bye
Shridhar

--
Wait! You have not been prepared! -- Mr. Atoz, "Tomorrow is Yesterday",
stardate 3113.2

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-10-28 14:01:57 Re: How can i get the column names?
Previous Message Jules Alberts 2002-10-28 14:01:17 Re: Can't start rhdb-admin