Re: Netflix Prize data - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Netflix Prize data
Date
Msg-id 24803.1160007491@sss.pgh.pa.us
Whole thread Raw
In response to Re: Netflix Prize data  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: Netflix Prize data  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
"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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Re: Netflix Prize data
Next
From: "Mark Woodward"
Date:
Subject: Re: Netflix Prize data