From: | Chantal Ackermann <chantal(dot)ackermann(at)web(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Multibyte or not? |
Date: | 2002-02-27 12:33:57 |
Message-ID: | 02022713335705.22209@guffert |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Crotwell | 2002-02-27 14:26:46 | Re: SET TRANSACTION ISOLATION LEVEL |
Previous Message | Marc Lavergne | 2002-02-27 07:10:21 | Re: hebrew and postgre |