how to improve performance in libpq?

Поиск
Список
Период
Сортировка
От Tony Liao
Тема how to improve performance in libpq?
Дата
Msg-id 8f750b7c0905131938i1be4339bu460d96ed8951d68a@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi,All,
     I have a question in libpq.the postgresql dadabase about 32MB(base on backup),and I tried to analyze query as :EXPLAIN ANALYZE SELECT .........where id=123 ,got the total actual time is 2.882ms.
     Now,I start a test programe base on ../src/test/examples/testlibpq.c ,which has 900 connection pools,and the id will be to increase for each query.In total I test 160000 queries, used time 1012s. That seems a greate different with 2.88ms/each query.    any idea?
     test environment      :
     database hardware    CUP  2*Xeon 5405
                                    MEMORY  DDR2 16GB/800 with DIMM
                                    HARDISK   160GB/8M SATA
      network :LAN 1Gbps 
     
 
      configuration files:
         max_connections = 3000
         shared_buffers = 64MB  
         work_mem = 4MB                      
         maintenance_work_mem = 4MB            
         max_stack_depth = 1MB                  
         the others as default.
       
        any idea?
        I hope you can understand,thanks.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: contrib modules script policy?
Следующее
От: Tony Liao
Дата:
Сообщение: Re: how to improve performance in libpq?