Re: Netflix Prize data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
Cc: pg(at)mohawksoft(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Netflix Prize data
Date: 2006-10-04 21:00:52
Message-ID: 21651.1159995652@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Mark Woodward" <pgsql(at)mohawksoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-10-04 21:19:28 Re: SQL:2003 Statistical functions - What are they?
Previous Message Luke Lonergan 2006-10-04 21:00:00 Re: Netflix Prize data