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, bouchia.nazha@free.fr 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 decibel@decibel.org
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?"
