Skip site navigation (1) Skip section navigation (2)

Re: PGSQL Capacity

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PGSQL Capacity
Date: 2005-05-10 21:40:24
Message-ID: 20050510214024.GO31103@decibel.org (view raw or flat)
Thread:
Lists: pgsql-performance
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(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. NasbyDate: 2005-05-10 21:45:31
Subject: Re: Configing 8 gig box.
Previous:From: Mischa SandbergDate: 2005-05-10 21:35:58
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group