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.
max_stack_depth = 1MB
the others as default.
any idea?
I hope you can understand,thanks.
В списке pgsql-admin по дате отправления: