Message-ID: <21629.24.91.171.78.1160008114.squirrel@mail.mohawksoft.com>
In-Reply-To: <24803.1160007491@sss.pgh.pa.us>
References: <306b3b90a0fa1014e09717b77cca886b@biglumber.com>
	<87hcyj64d2.fsf@enterprisedb.com>
	<21728.24.91.171.78.1160006000.squirrel@mail.mohawksoft.com>
	<24803.1160007491@sss.pgh.pa.us>
Date: Wed, 4 Oct 2006 20:28:34 -0400 (EDT)
Subject: Re: Netflix Prize data
From: "Mark Woodward" <pgsql@mohawksoft.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Gregory Stark" <stark@enterprisedb.com>,
	"Greg Sabino Mullane" <greg@turnstep.com>, pgsql-hackers@postgresql.org
User-Agent: SquirrelMail/1.4.7
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

> "Mark Woodward" <pgsql@mohawksoft.com> writes:
>> The rating, however, is one char 1~9. Would making it a char(1) buy
>> anything?
>
> No, that would actually hurt because of the length word for the char
> field.  Even if you used the "char" type, which really is only one byte,
> you wouldn't win anything because of alignment issues.  Personally I'd
> just go for three ints and a date, rather than trying to be cute with
> the rating.


Actually, the date is just days, right? I don't actualy need it too much.
So, create a small int for date and do this: smalldate =
date('1970-01-01') - rdate. And use small int for rating.

 Column |   Type   | Modifiers
--------+----------+-----------
 movie  | integer  |
 client | integer  |
 day    | smallint |
 rating | smallint |