"Jay Greenfield" <jag@timberline.ca> writes:
> The table is 1.2 million rows X 246 columns. The only index is the primary
> key. I will try to remove that index to see if that improves performance at
> all.
Hmm, the large number of columns might have something to do with it ...
what datatypes are the columns?
regards, tom lane