Skip site navigation (1) Skip section navigation (2)

Re: How to get higher tps

From: "Marty Jia" <mjia(at)ask(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>,"DBAs" <DBAs(at)ask(dot)com>,"Rich Wilson" <richwilson(at)ask(dot)com>,"Ernest Wurzbach" <EWurzbach(at)ask(dot)com>
Subject: Re: How to get higher tps
Date: 2006-08-22 13:19:40
Message-ID: 0B9A8C89DCC3AB488A78A4DE0FECDA90019E31E1@SITE3MAIL04.jeeves.ask.info (view raw or flat)
Thread:
Lists: pgsql-performance
Joshua,

Here is 

shared_buffers = 80000
fsync = on
max_fsm_pages = 350000
max_connections = 1000
work_mem = 65536
effective_cache_size = 610000
random_page_cost = 3
 
Here is pgbench I used:

pgbench -c 10 -t 10000 -d HQDB

Thanks

Marty

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com] 
Sent: Monday, August 21, 2006 6:09 PM
To: Marty Jia
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] How to get higher tps

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/



In response to

Responses

pgsql-performance by date

Next:From: Mark LewisDate: 2006-08-22 14:31:49
Subject: Re: How to get higher tps
Previous:From: Tom LaneDate: 2006-08-22 13:17:04
Subject: Re: Postgre SQL 7.1 cygwin performance issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group