Performance question - Mailing list pgsql-admin

From Brian McCane
Subject Performance question
Date
Msg-id 20020226033228.B17694-100000@fw.mccons.net
Whole thread Raw
In response to problems with PgAdmin and database encoding.  (Manuel Trujillo <manueltrujillo@dorna.es>)
Responses Re: Performance question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
First of all, I have somewhat fixed my locking problems from before, at
least to the point that the app is mostly usable.  I will tweak it more
later, when I have some more free time to myself :)

Now:
    I use an english alphabet exclusively in an app I am working on
for another customer.  If I need to put non-english characters, I use the
HTML encoding functions from HTML::Entities in Perl.  This causes me to
store strings like:

You’re antique vase cost ¥5.000.000

Okay, you get the picture any way.

Since I am using a strict alphabet like this, would it be faster to build
PostgreSQL without Multibyte support?  Or has the indexing, etc. been
optimized so much for multibyte that it is actually faster than single
byte stuff?

- brian


Wm. Brian McCane                    | Life is full of doors that won't open
Search http://recall.maxbaud.net/   | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"



pgsql-admin by date:

Previous
From: Manuel Trujillo
Date:
Subject: problems with PgAdmin and database encoding.
Next
From: Jean-Michel POURE
Date:
Subject: Re: problems with PgAdmin and database encoding.