"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