problems with pgadmin 3

From: jose fuenmayor <jafn82(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: problems with pgadmin 3
Date: 2005-07-05 18:27:14
Message-ID: 69f2062a0507051127c37e866@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

Hi good afternoon everyone, my name is Jose Antonio Fuenmayor Nava, I
am Venezuelan, I work as a Systems Analist in Reingenieria y Sistemas
C.A, that´s a company that operates in Maracaibo, Venezuela, this
company manages huges amounts of data, yesterday i was trying Pgadmin
3, I performed the following sql instruction

select * from table_name

this table has 10 777 893 registers on it (13 fields), with no indexes
just to try the performance of PostgreSql and pgAdmin 3 and evaluate
the behavior of this aplications, I have postgresql database server
installed and pgadmin 3 on a machine running Mandrake Linux 10.1,
Pgadmin 3 performed the consult but in the moment of bringing the data
to the grid it seems to collapse and it just shut down (not the
database server, but PgAdmin 3), now my question is:

is this normal?

I´ve installed pgadmin 3 from a rpm.

I really apreciate it if you can help me in any way, the company that
i work for is really interested in migrate the database from Informix
to PostgreSql, and from Windows/Unix OpenServer 5 to GNU/Linux, but
for now we are just testing.

We are about to fill a table with 177 000 000 of registers and play
with it just to see the performance.

All yours
Jose Antonio Fuenmayor Nava
Systems Analist
Reingenieria y Sistemas C.A
Maracaibo, Venezuela.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message jose fuenmayor 2005-07-05 18:44:00 Fwd: problems with pgadmin 3
Previous Message Bruce Momjian 2005-07-05 16:51:28 Re: replication for hot-standby?

Browse pgsql-bugs by date

  From Date Subject
Next Message jose fuenmayor 2005-07-05 18:44:00 Fwd: problems with pgadmin 3
Previous Message Tom Lane 2005-07-05 18:25:07 Re: Error installing Postgres on Solaris 9