Horton

Re: dependency between numbers keywords and parser speed

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Mark Wong <markwkm@gmail.com>
Date: 2011-03-14T20:46:47Z
Lists: pgsql-hackers 
On 3/14/11 1:34 PM, Tom Lane wrote:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> there was a discussion about impact of number of keyword for parser
>> speed. I did some synthetic tests and I didn't see any slowness on
>> pgbench when I increased a number of keywords.
> 
> I don't see any particular reason to suppose that pgbench would be a
> good framework for stressing parsing speed.  The queries it issues
> are of trivial length.

TPC-H might work well.  Mark, is DBT3 still in usable condition?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com