How to get higher tps

Поиск
Список
Период
Сортировка
От Marty Jia
Тема How to get higher tps
Дата
Msg-id 0B9A8C89DCC3AB488A78A4DE0FECDA90019E30D4@SITE3MAIL04.jeeves.ask.info
обсуждение исходный текст
Ответы Re: How to get higher tps
Re: How to get higher tps
Re: How to get higher tps
Re: How to get higher tps
Список pgsql-performance
I'm exhausted to try all performance tuning ideas, like following
parameters

shared_buffers
fsync
max_fsm_pages
max_connections
shared_buffers
work_mem
max_fsm_pages
effective_cache_size
random_page_cost

I believe all above have right size and values, but I just can not get
higher tps more than 300 testd by pgbench

Here is our hardware


Dual Intel Xeon 2.8GHz
6GB RAM
Linux 2.4 kernel
RedHat Enterprise Linux AS 3
200GB for PGDATA on 3Par, ext3
50GB for WAL on 3Par, ext3

With PostgreSql 8.1.4

We don't have i/o bottle neck.

Whatelse I can try to better tps? Someone told me I can should get tps
over 1500, it is hard to believe.

Thanks

Marty

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum not identifying rows for removal..
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: How to get higher tps