X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84BB8DA3AD for ; Thu, 6 Oct 2005 10:25:44 -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 62196-08 for ; Thu, 6 Oct 2005 13:25:40 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id 99E23DA3A4 for ; Thu, 6 Oct 2005 10:25:40 -0300 (ADT) Received: from dariop (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j96EObp12573; Thu, 6 Oct 2005 11:24:39 -0300 Received: from 127.0.0.1 (AVG SMTP 7.0.344 [267.11.11]); Thu, 06 Oct 2005 10:25:56 -0300 From: "Dario" To: "dedy" , Subject: Re: faster or ..... ???? Date: Thu, 6 Oct 2005 10:25:56 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <20051006045440.18119.qmail@mail.unika.ac.id> X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.039 required=5 tests=[AWL=0.039] X-Spam-Level: X-Archive-Number: 200510/80 X-Sequence-Number: 19152 1) mmm... create table x as object doesn't seem to be a valid = statement.... You can create types, or use arrays. But I think you don't = need (neither want) that...=20 2) (which one is faster?) I'm not sure what are your plans for this = tables. How many rows are you trying to insert into address for each ID? = do you need to search for address? As a programmer, I definitly wouldn't = do something like the first option (using arrays) except that I'm = positibly sure that I will ALWAYS (no exception) retreat all address = everytime I need an "id" record and they are not too many for each id. = And I (or my bosses) will never want to look people for address. As a = dba, I would kill that programmer. 3) My english s*cks too. -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]En nombre de dedy Enviado el: jueves, 06 de octubre de 2005 1:55 Para: pgsql-admin@postgresql.org Asunto: [ADMIN] faster or ..... ???? Hii all, I eould like to asking about creating table in postgres here is the 1> can postgres do such things like this one? # create table address as object(address varchar(100), post(6)); # create table id (id integer not null primary key, name char(100),address);=20 now i will compare with this one >> # create table id (id integer not null primary key, name char(100)); # create table address (id integer not null references id, address varchar(100), post(6));=20 which is most faster???=20 Thank you very much for all your kind to answer my question and my english is so bad isn't?=20 Dedy Styawan Semarang ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings