From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: PGSQL Capacity
Date: Mon, 9 May 2005 21:32:18 +0200
Message-ID: <20050509193218.GB12502@uio.no> (raw)
In-Reply-To: <1115666560.427fb8803c3a6@imp1-q.free.fr>
References: <1115666560.427fb8803c3a6@imp1-q.free.fr>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com
Subject: Re: PGSQL Capacity
In-Reply-To: <20050509193218.GB12502@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox