From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Hardman <peter@ssbg.zetnet.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL
Date: Thu, 17 Aug 2006 20:31:51 -0400
Message-ID: <965.1155861111@sss.pgh.pa.us> (raw)
In-Reply-To: <44E4DBE7.22131.10181D0@peter.ssbg.zetnet.co.uk>
References: <5321.1155820310@sss.pgh.pa.us>
<44E4DBE7.22131.10181D0@peter.ssbg.zetnet.co.uk>
"Peter Hardman" <peter@ssbg.zetnet.co.uk> writes:
> On 17 Aug 2006 at 14:33, Tom Lane wrote:
>> I found a couple of minor planner problems, which I've repaired in CVS
>> HEAD. You might consider using TEXT columns instead of VARCHAR(n),
> As someone else suggested, these fields ought really to be CHAR no VARCHAR.
That should be fine too. VARCHAR is sort of a poor stepchild in
Postgres, because it piggybacks on TEXT's operators --- but CHAR
has different comparison rules, hence its own operators, hence
doesn't trip over that bug.
There's still some things that don't add up to me, like the question
of the pkey column order. Will look some more.
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, peter@ssbg.zetnet.co.uk
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL
In-Reply-To: <965.1155861111@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