Multibyte or not?
От | Chantal Ackermann |
---|---|
Тема | Multibyte or not? |
Дата | |
Msg-id | 02022713335705.22209@guffert обсуждение исходный текст |
Ответы |
Re: Multibyte or not?
|
Список | 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
В списке pgsql-jdbc по дате отправления: