array vs flat tables performance

From: "Oren Mazor" <oren(dot)mazor(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: array vs flat tables performance
Date: 2005-08-29 18:43:30
Message-ID: op.sv98ysuvv14azh@oren-mazors-computer.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm about to add another table to the project I'm working on and the
suggested plan of action is to use arrays. Since performance is an issue,
I'm wondering, what exactly is the difference?

in other words, I could have a flat table such as:

UID1 - ITEM1
UID1 - ITEM2
UID1 - ITEM3
UID7 - ITEM12

or I could use arrays:

UID1 - {ITEM1,ITEM2,ITEM3}
UID7 - {ITEM12}

is the latter simply syntactic sugar for the former?

thanks
Oren

--
Oren Mazor // Developer, Sysadmin, Explorer
GPG Key: http://www.grepthemonkey.org/secure
"Ut sementem feceris, ita metes"

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Stange 2005-08-29 19:11:14 understanding the interaction with delete/select/vacuum
Previous Message Jaromír Kamler 2005-08-29 09:13:15 Fwd: Re: question - plpgsql and query on table given by variable