Re: Table Creation Question.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <postgres(at)athena(dot)frontlogic(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table Creation Question.
Date: 2001-04-26 15:41:09
Message-ID: Pine.LNX.4.30.0104261740210.758-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

postgres(at)athena(dot)frontlogic(dot)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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-04-26 15:47:38 Re: Re: Need for newbie friendly docs (was Newbie struggling...)
Previous Message Peter Eisentraut 2001-04-26 15:39:43 Re: Classes of returned rows