pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Wong <markw@osdl.org>
To: Manfred Spraul <manfred@colorfullife.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: neilc@samurai.com
Cc: pgsql-performance@postgresql.org
Subject: Re: futex results with dbt-3
Date: Thu, 21 Oct 2004 06:54:58 -0700
Message-ID: <20041021065458.A5580@osdl.org> (raw)
In-Reply-To: <41774D11.1030906@colorfullife.com>
References: <417221B5.1050704@colorfullife.com>
	<20151.1098222733@sss.pgh.pa.us>
	<417697A5.1050600@colorfullife.com>
	<7178.1098292535@sss.pgh.pa.us>
	<4176A2C1.3070205@colorfullife.com>
	<20041020150528.B7838@osdl.org>
	<41774D11.1030906@colorfullife.com>

On Thu, Oct 21, 2004 at 07:45:53AM +0200, Manfred Spraul wrote:
> Mark Wong wrote:
> 
> >Here are some other details, per Manfred's request:
> >
> >Linux 2.6.8.1 (on a gentoo distro)
> >  
> >
> How complicated are Tom's test scripts? His immediate reply was that I 
> should retest with Fedora, to rule out any gentoo bugs.
> 
> I have a dual-cpu system with RH FC, I could use it for testing.
> 

Pretty, simple.  One to load the database, and 1 to query it.  I'll 
attach them.

Mark

Attachments:

test_createscript.sql (text/plain, 1.1K) download drop table test_data; create table test_data(f1 int); insert into test_data values (random() * 100); insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; insert into test_data select random() * 100 from test_data; create index test_index on test_data(f1); vacuum verbose analyze test_data; checkpoint;
test_script.sql (text/plain, 308B) download -- force nestloop indexscan plan set enable_seqscan to 0; set enable_mergejoin to 0; set enable_hashjoin to 0; explain select count(*) from test_data a, test_data b, test_data c where a.f1 = b.f1 and b.f1 = c.f1; select count(*) from test_data a, test_data b, test_data c where a.f1 = b.f1 and b.f1 = c.f1;

view thread (24+ messages)  latest in thread

Message-ID: <20041021065458.A5580@osdl.org>
Permalink:  ../20041021065458.A5580@osdl.org/
Also on:    postgresql.org/message-id/20041021065458.A5580@osdl.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markw@osdl.org, manfred@colorfullife.com, tgl@sss.pgh.pa.us, neilc@samurai.com
  Subject: Re: futex results with dbt-3
  In-Reply-To: <20041021065458.A5580@osdl.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox