Re: dependency between numbers keywords and parser speed - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: dependency between numbers keywords and parser speed
Date
Msg-id 4D7E7EB7.20409@agliodbs.com
Whole thread Raw
In response to Re: dependency between numbers keywords and parser speed  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: dependency between numbers keywords and parser speed
Next
From: Greg Stark
Date:
Subject: Re: really lazy vacuums?