Re: Table Creation Question. - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Table Creation Question.
Date
Msg-id Pine.LNX.4.30.0104261740210.758-100000@peter.localdomain
Whole thread Raw
In response to Table Creation Question.  (<postgres@athena.frontlogic.com>)
List pgsql-general
postgres@athena.frontlogic.com writes:

> I assume using the array type would save me some cost on storage, while
> using the varchar/integer pairs would result in faster queries.  Is this
> correct?  Thanks for any help or pointers.

As long as you don't want to look up or join against invidual array
members, the array solution is going to be more space and time efficient.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: using POSTGRES in a network
Next
From: "Tamsin"
Date:
Subject: updating with max value