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

Re: [GENERAL] PostgreSQL TPC-H test result?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, Amber <guxiaobo1982(at)hotmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [GENERAL] PostgreSQL TPC-H test result?
Date: 2008-09-12 03:48:06
Message-ID: 24184.1221191286@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
"Jignesh K. Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> writes:
> * However Empty rows results is occuring consistently
>   (Infact Q11 also returned empty for me while it worked in their test)
>   Queries: 4,5,6,10,11,12,14,15
>   (ACTION ITEM: I will start separate threads for each of those queries in
>    HACKERS alias to figure out the problem since it looks like Functional
>    problem to me and should be interesting to hackers alias)

See discussion suggesting that this is connected to misinterpretation of
INTERVAL literals.  If TPC-H relies heavily on syntax that we'd get
wrong, then pretty much every test result has to be under suspicion,
since we might be fetching many more or fewer rows than the test
intends.

I've recently committed fixes that I think would cover this, but you'd
really need to compare specific query rowcounts against other DBMSes
to make sure we're all on the same page.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2008-09-12 04:09:21
Subject: Re: Effects of setting linux block device readahead size
Previous:From: Jignesh K. ShahDate: 2008-09-12 03:30:39
Subject: Re: PostgreSQL TPC-H test result?

pgsql-general by date

Next:From: Jonah H. HarrisDate: 2008-09-12 04:46:55
Subject: Re: [GENERAL] PostgreSQL TPC-H test result?
Previous:From: GoboxeDate: 2008-09-12 03:34:54
Subject: Trigger does not behave as expected

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