http://stats.distributed.net 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, bouchia(dot)nazha(at)free(dot)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(at)decibel(dot)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?"
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2005-05-10 21:45:31|
|Subject: Re: Configing 8 gig box.|
|Previous:||From: Mischa Sandberg||Date: 2005-05-10 21:35:58|
|Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL|