dependency between numbers keywords and parser speed

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: dependency between numbers keywords and parser speed
Date: 2011-03-14 20:11:52
Message-ID: AANLkTik=PsqxLdGFa4A71Pnx7n1WE1UyOpxVnc4RXVHb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

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 added a 30 reserved keywords and 30 unreserved keywords.

On my Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz wasn't a
significant difference between patched and unpatched server.

Tested read only queries. I am sure, so there will be any dependency,
but it probably needs more keywords, then I tested.

Regards

Pavel Stehule

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-03-14 20:18:13 Re: really lazy vacuums?
Previous Message Tom Lane 2011-03-14 20:05:43 Unknown constants vs UNION