X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BD5C05280D for ; Tue, 5 Jul 2005 15:27:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63956-04 for ; Tue, 5 Jul 2005 18:27:16 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205]) by svr1.postgresql.org (Postfix) with ESMTP id 87B5252856 for ; Tue, 5 Jul 2005 15:27:13 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so474372nzo for ; Tue, 05 Jul 2005 11:27:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=lN+M0vJFqcdKnHS2hgUdsN5qkBIeCc+K0LOMnHwEAtNDL+twsClku17w804Kc6YnAwFQlsX1VgQ+48dOjEtaXixtBPBh7hOwa7KgXw8MSHRgTfv77zmH2688I6wce/xhcAqZjVvLTvVIgB0CBtm8dFN6vRzlPwCzJ65rhsMqR2c= Received: by 10.36.141.10 with SMTP id o10mr561513nzd; Tue, 05 Jul 2005 11:27:14 -0700 (PDT) Received: by 10.36.59.4 with HTTP; Tue, 5 Jul 2005 11:27:14 -0700 (PDT) Message-ID: <69f2062a0507051127c37e866@mail.gmail.com> Date: Tue, 5 Jul 2005 14:27:14 -0400 From: jose fuenmayor Reply-To: jose fuenmayor To: pgsql-admin@postgresql.org Subject: problems with pgadmin 3 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.372 tagged_above=0 required=5 tests=FROM_ENDS_IN_NUMS, RCVD_BY_IP, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: ** X-Archive-Number: 200507/26 X-Sequence-Number: 18082 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=B4s 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=B4ve 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.