Postgres Pro
Downloads
Home   >   mailing lists

Re: Netflix Prize data - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Netflix Prize data
Date
Msg-id 21651.1159995652@sss.pgh.pa.us
Whole thread Raw
In response to Netflix Prize data  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: Netflix Prize data  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
Tree view 
"Mark Woodward" <pgsql@mohawksoft.com> writes:
> The one thing I notice is that it is REAL slow.

How fast is your disk?  Counting on my fingers, I estimate you are
scanning the table at about 47MB/sec, which might or might not be
disk-limited...

> I'm using 8.1.4. The "rdate" field looks something like: "2005-09-06"

So why aren't you storing it as type "date"?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Netflix Prize data
Next
From: Bruce Momjian
Date:
Subject: Re: SQL:2003 Statistical functions - What are they?