Re: JDBC en PostgreSQL 6.3.2

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 |
+------------------------------------------------------+

In response to

Responses

Browse pgsql-es-ayuda by date

  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