Postgres Pro
Downloads
Home   >   mailing lists

array vs flat tables performance - Mailing list pgsql-novice

From Oren Mazor
Subject array vs flat tables performance
Date
Msg-id op.sv98ysuvv14azh@oren-mazors-computer.local
Whole thread Raw
Responses Re: array vs flat tables performance
List pgsql-novice
Tree view 
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"

pgsql-novice by date:

Previous
From: " Jaromír Kamler"
Date:
Subject: Fwd: Re: question - plpgsql and query on table given by variable
Next
From: Alan Stange
Date:
Subject: understanding the interaction with delete/select/vacuum