Re: newbie table design question - Mailing list pgsql-general

From Sam Mason
Subject Re: newbie table design question
Date
Msg-id 20090601124146.GO5407@samason.me.uk
Whole thread Raw
In response to Re: newbie table design question  ("Chris Spotts" <rfusca@gmail.com>)
Responses Re: newbie table design question
List pgsql-general
On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
> I just finished doing something very close to this - not quite once per
> minute, but close.  I started off with an array of integers and after about
> a month of it, I'm having to redesign my way out of it.

I've had to go the other way before; started with a nicely normalized
design but the performance overhead (and query complexity to a lesser
extent) made the design unworkable.  As always the design depends on the
specifics of the problem, but as the OP said he was new to PG I thought
it good to point out its support for arrays.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: "Chris Spotts"
Date:
Subject: Re: newbie table design question
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: newbie table design question