Re: Error in running DBT2

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Error in running DBT2
Date: 2014-05-13 22:20:12
Message-ID: CAM3SWZSxANs_qZw57EqPN+cHR1ot3awAk6Q9E3abhGPC4eUe2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 13, 2014 at 2:51 PM, David G Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> The error is more typical of someone creating a database with UTF-8 encoding
> but then tries storing Latin-1 (or some other) encoded data.

I didn't say that it was the only problem. Just that I had noticed
that other people were using standard_conforming_strings = off when
running DBT2, on the couple of occasions were I looked through a
result set. The fact that this may have accidentally worked before,
when that was the default does not imply that it was ever correct, but
it may at least be possible to get it to work at least as well as it
ever did by doing that. DBT2 doesn't seem to have anything to say
about encoding one way or the other. As I said, it has many problems.
Another thing that I noticed that I didn't like was that it uses the C
locale.

--
Peter Geoghegan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-05-13 22:58:11 gettimeofday is at the end of its usefulness?
Previous Message David G Johnston 2014-05-13 21:51:25 Re: Error in running DBT2