> Hmm, the large number of columns might have something to do with it ... > what datatypes are the columns?
All sorts, but mostly float4 and varchar(2 to 10) Jay -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 1:03 PM To: Jay Greenfield Cc: 'Stephen Frost'; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgres slower than MS ACCESS "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 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
