From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: PGSQL Capacity
Date: Mon, 09 May 2005 17:46:23 -0400
Message-ID: <60ll6oul74.fsf@dba2.int.libertyrms.com> (raw)
References: <1115666560.427fb8803c3a6@imp1-q.free.fr>
bouchia.nazha@free.fr writes:
> 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.
The capacity is much more likely to be limited by the size of the disk
drives and filesystems you have available to you than by anything
else.
If your table consists of 8- 32 character strings, then each tuple
will consume around 256 bytes of memory, and you will be able to fit
on the order of 30 tuples into each 8K page.
By default, you can extend a single table file to up to 1GB before it
splits off to another piece. That would mean each file can have about
3.9M tuples. From there, you can have as many 1GB pieces as the disk
will support. So you could have (plenty * 3.9M tuples), which could
add up to be rather large.
If you're expecting 50K records, that will be no big deal at all.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www.ntlug.org/~cbbrowne/sap.html
Rules of the Evil Overlord #78. "I will not tell my Legions of Terror
"And he must be taken alive!" The command will be: ``And try to take
him alive if it is reasonably practical.''"
<http://www.eviloverlord.com/;
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: cbbrowne@acm.org
Subject: Re: PGSQL Capacity
In-Reply-To: <60ll6oul74.fsf@dba2.int.libertyrms.com>
* 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