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
>