From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jay Greenfield <jag@timberline.ca>
Cc: 'Stephen Frost' <sfrost@snowman.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres slower than MS ACCESS
Date: Tue, 14 Feb 2006 16:02:32 -0500
Message-ID: <22608.1139950952@sss.pgh.pa.us> (raw)
In-Reply-To: <200602142056.k1EKuIiO002595@timberline.ca>
References: <200602142056.k1EKuIiO002595@timberline.ca>
"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: tgl@sss.pgh.pa.us, jag@timberline.ca, sfrost@snowman.net
Subject: Re: Postgres slower than MS ACCESS
In-Reply-To: <22608.1139950952@sss.pgh.pa.us>
* 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