Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-es-ayuda by date

Next:From: Salvador Fernndez BarqunDate: 1998-06-04 07:38:23
Subject: Sobre ODBC con Postgresql 6.3.1 o el que sea.
Previous:From: PostreSQL ServerDate: 1998-06-03 17:39:28
Subject: Re: JDBC en PostgreSQL 6.3.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group