> 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:tgl@sss.pgh.pa.us]
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" <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