Message-ID: <4C59BD14.8000204@2ndquadrant.com>
Date: Wed, 04 Aug 2010 15:18:44 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Hannu Krosing <hannu@2ndquadrant.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>,
	Peter Hussey <peter@labkey.com>,
	pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Questions on query planner, join types, and work_mem
References: <AANLkTikMwVZKDYLitnsK31R=VNOuTH8NtmDHDGkBR7k8@mail.gmail.com>	
	<18551.1280275502@sss.pgh.pa.us>	
	<AANLkTimXMR0jMdw+66E4Xx=SqNV37Ne9WfkFjPFZVjbV@mail.gmail.com>	
	<25534.1280498632@sss.pgh.pa.us>	
	<AANLkTik3oY1=F_uC843c84LxBLNdHxZaWdfjxrAtyBeu@mail.gmail.com>	
	<1280819031.14579.38.camel@hvost>	
	<AANLkTik6UBt2ezVFzdCM8iaUPkra_7f-Hs_AmGZgvFhh@mail.gmail.com>	
	<1280944268.3735.12.camel@hvost> <22961.1280944836@sss.pgh.pa.us>	
	<1280947287.3735.56.camel@hvost> <1280948634.3735.69.camel@hvost>
	<4C59BCA8.2060603@2ndquadrant.com>
In-Reply-To: <4C59BCA8.2060603@2ndquadrant.com>
Content-Type: multipart/mixed; boundary="------------090501050808010701090006"

This is a multi-part message in MIME format.
--------------090501050808010701090006
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

This time with attachment...

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


--------------090501050808010701090006
Content-Type: application/x-sh;
 name="fsync-stress.sh"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="fsync-stress.sh"

#!/bin/bash
SCALE=100
if [ -n "$1" ] ; then
  SCALE="$1"
fi
dropdb pgbench
createdb pgbench
psql -c "select pg_stat_reset_shared('bgwriter')"
psql -x -c "select now(),* from pg_stat_bgwriter"
echo Initializing pgbench
pgbench -i -s $SCALE pgbench >> /dev/null 2>&1
psql -x -c "select now(),* from pg_stat_bgwriter"


--------------090501050808010701090006--