X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA0F7536F8 for ; Tue, 10 May 2005 18:40:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72314-02 for ; Tue, 10 May 2005 21:40:22 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8AB11533C1 for ; Tue, 10 May 2005 18:40:22 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 595BE154BE; Tue, 10 May 2005 16:40:24 -0500 (CDT) Date: Tue, 10 May 2005 16:40:24 -0500 From: "Jim C. Nasby" To: pgsql-performance@postgresql.org Subject: Re: PGSQL Capacity Message-ID: <20050510214024.GO31103@decibel.org> References: <1115666560.427fb8803c3a6@imp1-q.free.fr> <20050509193218.GB12502@uio.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050509193218.GB12502@uio.no> X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/167 X-Sequence-Number: 12331 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?"