"Jay Greenfield" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
