Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4BB889FB21D for ; Wed, 4 Oct 2006 19:32:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 99692-03 for ; Wed, 4 Oct 2006 19:32:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tinlc.com (unknown [72.18.206.65]) by postgresql.org (Postfix) with ESMTP id BB6449FA384 for ; Wed, 4 Oct 2006 19:32:42 -0300 (ADT) Received: from [127.0.0.1] (helo=localhost) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1GVFKG-00069J-LS; Wed, 04 Oct 2006 17:34:52 -0500 From: "Greg Sabino Mullane" To: pgsql-hackers@postgresql.org Subject: Re: Netflix Prize data X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <18350.24.91.171.78.1159994622.squirrel@mail.mohawksoft.com> Date: Wed, 4 Oct 2006 22:34:52 -0000 X-Mailer: JoyMail 2.01 Message-ID: <306b3b90a0fa1014e09717b77cca886b@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.189 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200610/255 X-Sequence-Number: 92152 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I signed up for the Netflix Prize. (www.netflixprize.com) > and downloaded their data and have imported it into PostgreSQL. > Here is how I created the table: I signed up as well, but have the table as follows: CREATE TABLE rating ( movie SMALLINT NOT NULL, person INTEGER NOT NULL, rating SMALLINT NOT NULL, viewed DATE NOT NULL ); I also recommend not loading the entire file until you get further along in the algorithm solution. :) Not that I have time to really play with this.... - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200610041827 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFFJDZ0vJuQZxSWSsgRAr6OAKCiOuspNm8QCsujaEN0Kgie6RsTjgCdGPda 9zVzpkrhTEhySEVBwMBTOdU= =zF7u -----END PGP SIGNATURE-----