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