Re: Fw: Speed diff cause by multi-byte support - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Fw: Speed diff cause by multi-byte support
Date
Msg-id 200203281628.g2SGSrc09479@candle.pha.pa.us
Whole thread Raw
In response to Fw: Speed diff cause by multi-byte support  ("Arsalan Zaidi" <azaidi@directi.com>)
List pgsql-general
So you are asking about compiling with multibyte and then using ASCII
for some initdb's and Unicode for others.  There are certain routines
that get replaced for multibyte/unicode which are slower than the
ASCII-only alternatvies, and these do apply to all databases, whether
initdb'ed with multibyte or not.  There is some penalty, and that is why
we don't enable multibyte by default.

---------------------------------------------------------------------------

Arsalan Zaidi wrote:
> > I read somewhere in the docs that turning on multi-byte support slows PG
> > down.
> >
> > I was wondering. If I compile multi-byte support in and then use PG to
> > access
> > both a db initdb'ed with supprot for UNICODE and another one which uses
> > plain
> > ASCII, will there be a difference in speed between the two?
> >
> > Will PG run as normal with the ASCII db and slower with the UNICODE db or
> > slower with both?
> >
> > Thanks in advance.
> >
> > --Arsalan.
> >
> > -------------------------------------------------------------------
> > People often hate those things which they do not know, or cannot
> understand.
> > --Ali Ibn Abi Talib (A.S.)
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pg_dump fails
Next
From: Joe Conway
Date:
Subject: Re: Escaping in C-language functions