Re: [PERFORM] How to get higher tps

s = 220.790077 (excluding connections establishing) -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 22, 2006 3:38 PM To: Marty Jia Cc: Bucky Jordan; Alex Turner; Mark Lewis; pgsql-performance@postgresql.org; DBAs; Rich Wilson; Ernest Wurzbach Subject

Re: [PERFORM] How to get higher tps

max_connections = 1000 work_mem = 65536 effective_cache_size = 61 random_page_cost = 3 Thanks Marty -Original Message- From: Bucky Jordan [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 22, 2006 3:23 PM To: Joshua D. Drake; Marty Jia Cc: Alex Turner; Mark Lewis; pgsql-performance@postgresql.org

Re: [PERFORM] How to get higher tps

_size = 61 random_page_cost = 3 Thanks -Original Message- From: Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 22, 2006 11:47 AM To: Marty Jia Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to get higher tps At 04:45 PM 8/21/2006, Marty Jia wrote: >I'm exh

Re: [PERFORM] How to get higher tps

:27 AMTo: Mark LewisCc: Marty Jia; Joshua D. Drake; pgsql-performance@postgresql.org; DBAs; Rich Wilson; Ernest WurzbachSubject: Re: [PERFORM] How to get higher tps Oh - and it's usefull to know if you are CPU bound, or IO bound.  Check top or vmstat to get an idea of thatAlex On 8/22/06,

Re: [PERFORM] How to get higher tps

1585657408 1960079576sdm  54.80 6.67   891.38   15547618 2076836720sdn  54.71 6.66   891.35   15509096 2076776352           From: Alex Turner [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 22, 2006 11:27 AMTo: Mark LewisCc: Marty Jia; Joshua D

Re: [PERFORM] How to get higher tps

The scaling factor is 20 I used -v and 2>/dev/null, now I got tps = 389.796376 (excluding connections establishing) This is best so far I can get Thanks -Original Message- From: Mark Lewis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 22, 2006 10:32 AM To: Marty Jia Cc: Joshu

Re: [PERFORM] How to get higher tps

:[EMAIL PROTECTED] Sent: Monday, August 21, 2006 6:09 PM To: Marty Jia Cc: pgsql-performance@postgresql.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 > f

Re: [PERFORM] How to get higher tps

Mark Lewis [mailto:[EMAIL PROTECTED] Sent: Monday, August 21, 2006 5:47 PM To: Marty Jia Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to get higher tps Not much we can do unless you give us more info about how you're testing (pgbench setup), and what you've done with

Re: [PERFORM] How to get higher tps

Jia Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to get higher tps On Mon, 2006-08-21 at 16:45 -0400, Marty Jia wrote: > I'm exhausted to try all performance tuning ideas, like following > parameters > > shared_buffers > fsync By "tuning" fsync,

[PERFORM] How to get higher tps

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 mor