Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Postgres slower than MS ACCESS
Date
Msg-id 22608.1139950952@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres slower than MS ACCESS  ("Jay Greenfield" <jag@timberline.ca>)
Responses Re: Postgres slower than MS ACCESS  ("Jay Greenfield" <jag@timberline.ca>)
List pgsql-performance
Tree view 
"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: "Jay Greenfield"
Date:
Subject: Re: Postgres slower than MS ACCESS
Next
From: Michael Fuhr
Date:
Subject: Re: SQL Function Performance