From: | Bruno Unna <bruno(at)iac(dot)com(dot)mx> |
---|---|
To: | Israel Zavalza Bahena <izavalza(at)buzon(dot)contanet(dot)mx> |
Cc: | "Pablo A(dot) Godel" <godel(at)iwcc(dot)com>, pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx, Juan Antonio Gonzalez Ramos <juanan(at)gugu(dot)usal(dot)es> |
Subject: | Re: JDBC en PostgreSQL 6.3.2 |
Date: | 1998-06-03 17:55:36 |
Message-ID: | 35758E18.59791373@iac.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Israel Zavalza Bahena wrote:
>
> que tanto es tantito ?????
>
> Pablo A. Godel wrote:
> >
> > > P.D. Alguien sabe hasta cuantos registros de una tabla mas o menos sencilla
> > > puede soportar postgresql? 50,000? 1,000,000?
> >
> > Tienen que ser mucho mas.
> >
> > Saludos,
> > Pablo Godel
> > --
> > -----------------------------------------------
> > The Internation Website Construction Co. (IWCC)
> > http://www.iwcc.com.ar
> > Miami - Sao Paulo - Buenos Aires - Lima
> > -----------------------------------------------
Bien, el dato exacto no lo hallo. Pero esto puede servir (espero).
Tomado
de Linux-Database-HOWTO.
6. PostgreSQL Supports Extremely Large Databases greater than 200 Gig
Performance of 32-bit cpu machines will rapidly decline when the
database size exceed 5 gig. You can run 30 gig database on 32-bit cpu
but it will not be very effective. There is limitation imposed on the
amount of RAM (maximum of 2 gig only), limitation on the file system
sizes and also on the operating system. The operating system on
32-bit cpu will be "bumping it's head" too many times on the "32-bit
ceiling".
If you need to use extremely large databases (greater than 5
gigabytes), it is strongly advised that you use 64-bit machines like
Digital Alpha cpu, Sun Ultra-sparc 64-bit cpu, Silicon graphics 64-bit
cpu, upcoming Intel Merced IA-64 cpu, HPUX 64bit machines, IBM 64-bit
machines. Compile PostgreSQL under 64-bit cpu and it can support huge
databases and large queries. Performance of PostgreSQL for queries on
large tables and databases will be several times faster than
PostgreSQL on 32-bit cpu machines. Advantage of 64-bit machines are
that you get very large memory addressing space and the operating
system can support very large file-systems, provide better performance
with large databases, support much larger memory(RAM), have more
capabilities etc..
Saludos.
--
+------------------------------------------------------+
| Bruno Unna |
| bruno(at)sac(dot)com(dot)mx Pub.key available ICQ:1858580 |
+------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Salvador Fernndez Barqun | 1998-06-04 07:38:23 | Sobre ODBC con Postgresql 6.3.1 o el que sea. |
Previous Message | PostreSQL Server | 1998-06-03 17:39:28 | Re: JDBC en PostgreSQL 6.3.2 |