Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance on very large indexed tables - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Performance on very large indexed tables
Date
Msg-id 3DBD90AB.28534.DA0C5@localhost
Whole thread Raw
In response to Performance on very large indexed tables  (Ingo Schellhammer <schellhammer@zbh.uni-hamburg.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: www.postgresql.org/idocs/index.php?tutorial-table.html
Next
From: "Jules Alberts"
Date:
Subject: Re: Can't start rhdb-admin