has a table that's 130M rows.
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

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:
> ---------------------------(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! 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])

Reply via email to