pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dario <dario_d_s@unitech.com.ar>
To: dedy <slackman@unika.ac.id>
To: pgsql-admin@postgresql.org
Subject: Re: faster or ..... ????
Date: Thu, 6 Oct 2005 10:25:56 -0300
Message-ID: <MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar> (raw)
In-Reply-To: <20051006045440.18119.qmail@mail.unika.ac.id>

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... 
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); 

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)); 

which is most faster??? 

Thank you very much for all your kind to answer my question
and my english is so bad isn't? 

Dedy Styawan
Semarang

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




view thread (3+ messages)  latest in thread

Message-ID: <MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar>
Permalink:  ../MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar/
Also on:    postgresql.org/message-id/MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dario_d_s@unitech.com.ar, slackman@unika.ac.id
  Subject: Re: faster or ..... ????
  In-Reply-To: <MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar>
  References: <20051006045440.18119.qmail@mail.unika.ac.id> <MHEDJHCKDNOEHJKHIOCJEEDNCIAA.dario_d_s@unitech.com.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox