Re: dependency between numbers keywords and parser speed

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-03-14T20:34:40Z
Lists: pgsql-hackers
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.

			regards, tom lane