From: Jay Greenfield <jag@timberline.ca>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'Stephen Frost' <sfrost@snowman.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres slower than MS ACCESS
Date: Tue, 14 Feb 2006 13:25:32 -0800
Message-ID: <200602142125.k1ELPWiO003835@timberline.ca> (raw)
In-Reply-To: <22608.1139950952@sss.pgh.pa.us>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jag@timberline.ca, tgl@sss.pgh.pa.us, sfrost@snowman.net
Subject: Re: Postgres slower than MS ACCESS
In-Reply-To: <200602142125.k1ELPWiO003835@timberline.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox