Re: Postgres slower than MS ACCESS - Mailing list pgsql-performance

From Jay Greenfield
Subject Re: Postgres slower than MS ACCESS
Date
Msg-id 200602142125.k1ELPWiO003835@timberline.ca
Whole thread Raw
In response to Re: Postgres slower than MS ACCESS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> 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


pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: SQL Function Performance
Next
From: "Paul Khavkine"
Date:
Subject: 8.2.1 on FreeBSD 5.4-RELEASE