Message-ID: <44EA2EE3.8030207@commandprompt.com>
Date: Mon, 21 Aug 2006 15:08:35 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.5 (X11/20060728)
MIME-Version: 1.0
To: Marty Jia <mjia@ask.com>
CC: pgsql-performance@postgresql.org
Subject: Re: How to get higher tps
References: 
 <0B9A8C89DCC3AB488A78A4DE0FECDA90019E30D4@SITE3MAIL04.jeeves.ask.info>
In-Reply-To: 
 <0B9A8C89DCC3AB488A78A4DE0FECDA90019E30D4@SITE3MAIL04.jeeves.ask.info>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Marty Jia wrote:
> 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

What values did you use?

> 
> 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. 

Are you sure? What does iostat say during a pgbench? What parameters are 
you passing to pgbench?

Well in theory, upgrading to 2.6 kernel will help as well as making your 
WAL ext2 instead of ext3.

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

1500? Hmmm... I don't know about that, I can get 470tps or so on my 
measily dual core 3800 with 2gig of ram though.

Joshua D. Drake


> 
> Thanks
> 
> Marty
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/