"Mark Woodward" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
