DB Performance Tuning

Поиск
Список
Период
Сортировка
От nilesh khode
Тема DB Performance Tuning
Дата
Msg-id 20060905150853.20091.qmail@web60521.mail.yahoo.com
обсуждение исходный текст
Ответы Re: DB Performance Tuning  ("Guido Neitzer" <guido.neitzer@gmail.com>)
Re: DB Performance Tuning  (romje@javaxpert.com)
Список pgsql-admin

Hello,

I am working on database performace tuning on Postgresql 8.1 database build on Suse 10 Linux dedicated server. I am having 32 GB of RAM and 8 CPUs.  


I have made minimum recommended settings under postgresql.conf (i.e shared_buffer, work_mem, and effective cache_size also kernel.shmmax)

 

I have run SQL queries using pg-admin, the query execution + retrieval time is 80% reduced over existing server.

But same I tested with JDBC, the query requires more time as compared with existing server.

 

Please help me out in this performance tuning.
Regards,
Nilesh

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Automating pg-admin
Следующее
От: "Guido Neitzer"
Дата:
Сообщение: Re: DB Performance Tuning