Re: ayuda

From: Horacio Miranda <hmiranda(at)gmail(dot)com>
To: "rmontoya(at)san(dot)com(dot)pe" <rmontoya(at)san(dot)com(dot)pe>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: ayuda
Date: 2005-08-08 18:35:39
Message-ID: f2b9e74905080811358cd39a2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

No sera que estas buscando el tamaño de la base y el tamaño de las tablas ?

http://www.postgresql.org/docs/faqs.FAQ.html#1.1
-----------
4.4) What is the maximum size for a row, a table, and a database?

These are the limits:

Maximum size for a database? unlimited (32 TB databases exist)
Maximum size for a table? 32 TB
Maximum size for a row? 1.6TB
Maximum size for a field? 1 GB
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column types
Maximum number of indexes on a table? unlimited

Of course, these are not actually unlimited, but limited to available
disk space and memory/swap space. Performance may suffer when these
values get unusually large.

The maximum table size of 32 TB does not require large file support
from the operating system. Large tables are stored as multiple 1 GB
files so file system size limits are not important.

The maximum table size and maximum number of columns can be quadrupled
by increasing the default block size to 32k.
---------------

On 8/8/05, rmontoya(at)san(dot)com(dot)pe <rmontoya(at)san(dot)com(dot)pe> wrote:
>
>
>
>
> Hola a todos, estoy buscando el tamaño maximo de sentencias que soporta
> PostgrSQL. En la informacion de MySQL encontre que su tamaño maximo es de 1
> GB y 16 MB es por defecto. Si alguno de ustedes tiene esta informacion por
> favor hagamelo saber. Gracias
>
> Rafael
>
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 8: explain analyze es tu amigo
>

--
Saludos Horacio Miranda.
RedHat Certified Engineer.

In response to

  • Re: ayuda at 2005-08-08 17:28:05 from rmontoya

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Julio Cesar Culebro Gonzalez 2005-08-08 19:00:56 Re: SINCRONIZAR TABLAS
Previous Message Horacio Miranda 2005-08-08 18:28:27 Re: SINCRONIZAR TABLAS