Re: Postgres slower than MS ACCESS

> 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, February 14, 2006 1:03 PM
To: Jay Greenfield
Cc: 'Stephen Frost'; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Postgres slower than MS ACCESS

"Jay Greenfield" <jag(at)timberline(dot)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