| From: | "Marty Jia" <mjia(at)ask(dot)com> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | How to get higher tps |
| Date: | 2006-08-21 20:45:11 |
| Message-ID: | 0B9A8C89DCC3AB488A78A4DE0FECDA90019E30D4@SITE3MAIL04.jeeves.ask.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-21 21:06:28 | Re: Vacuum not identifying rows for removal.. |
| Previous Message | Scott Matseas | 2006-08-21 20:25:10 | Re: Index usage |