- 论坛徽章:
- 0
|
hope this setting is helpful for you
- $PGDATA/postgresql.conf
- ============================================================
- max_connections = 180
- # it's enough to support the concurrent connection
- shared_buffers = 30000
- # 30000*8k=240M ~ 10% of Phy Mem
- work_mem = 1024
- # 512k
- maintenance_work_mem = 1258292
- # 60% of Phy Mem
- checkpoint_segments = 30
- # (30*2+1)*16M ~1G disk space required, and if posible,
- # please mount $PGDATA/pg_xlog
- # to sigal disk, it can improve a little performance
- checkpoint_timeout = 300
- # use default value
- ============================================================
复制代码
and remember that:
run
VACUUM FULL VERBOSE ANALYZE daily and
VACUUM FREEZE VERBOSE ANALYZE weekly
你的SQL PL/pgSQL 代码也需要优化才可以达到很好的性能
具体的参数可以去看看手册,第16,17章
[ 本帖最后由 horseman 于 2006-12-19 11:30 编辑 ] |
|