Re: Multibyte or not?

Hi Barry,

Is there any way I can check out if my installation has the multibyte support? Or anyone can tell the pre-compiled Red
hatrpm package support multibyte or not?
 

Thanks!
Anthony

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org 
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Barry Lind
> Sent: Wednesday, February 06, 2002 10:34 AM
> To: chantal.ackermann@web.de
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] Multibyte or not?
> 
> 
> Chantal,
> 
> If you are using the 7.2 jdbc driver, you would only need to have 
> multibyte support compiled into the server if you wanted to store 
> multibyte characters.
> 
> --Barry
> 
> Chantal Ackermann wrote:
> > Hello all,
> > 
> > at the mysql-admin list I found a posting that says a 
> non-multibyte built of 
> > the database would be faster than a multibyte one. My question 
> is - do I 
> > always need a multibyte built if I plan to access the db with 
> jdbc or do i 
> > only need it if the data is non-ascii? i know that java uses 
> unicode but does 
> > that really matter unless I want to enter non-ascii letters?
> > 
> > actually this came to my mind when I was in search for some 
> tuning hints. I 
> > don't think this is the right place to ask this (would 
> 'psql-admin' be that?) 
> > - but maybe one of you had similar problems?
> > I am doing a lot of checking and inserting at runtime. while 
> the java thread 
> > holds ~38Mb (~500Mb) it uses only 1.7% CPU (~900Hz). postgresql 
> uses less 
> > than 4Mb at more than 90% CPU. I already doubled the effective 
> cache size to 
> > be '2000' but that did not change anything.
> > 
> > I wonder if the postgres would be faster if it would use more 
> RAM. or is this 
> > the bottle neck's end (unless I get a better CPU)?
> > 
> > thank you
> > Chantal
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> > 
> > 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
>