http://stats.distributed.net has a table that's 130M rows. http://stats.distributed.net/participant/phistory.php?project_id=8&id=39622 is a page that hits that table, and as you can see it's quite fast. This is on a dual opteron with 4G of memory.
Unless you're looking for sub millisecond response times, 50k rows is nothing. On Mon, May 09, 2005 at 09:32:18PM +0200, Steinar H. Gunderson wrote: > On Mon, May 09, 2005 at 09:22:40PM +0200, [EMAIL PROTECTED] wrote: > > How can i know a capacity of a pg database ? > > How many records my table can have ? > > I saw in a message that someone have 50 000 records it's possible in a > > table ? > > (My table have 8 string field (length 32 car)). > > Thanks for your response. > > You can have several million records in a table easily -- I've done 10 > million personally, but you can find people doing that many records a _day_. > Hitting 1 billion records should probably not be impossible either -- it all > depends on your hardware, and perhaps more importantly, what kind of queries > you're running against it. 50000 is absolutely no problem at all. > > /* Steinar */ > -- > Homepage: http://www.sesse.net/ > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])