From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: dependency between numbers keywords and parser speed |
Date: | 2011-03-15 01:07:43 |
Message-ID: | AANLkTimKepxX08TknwiTfdAu6XU6maTFKJqUwrnmEJjX@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Mar 14, 2011 at 4:34 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
I found that it was actually a fairly measurable component of the
select-only test when running with shared_buffers cranked up to a
reasonable value. But it'd probably be a lot easier to measure on a
benchmark specifically targeted at the parser.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2011-03-15 01:10:05 | Re: Better estimates of index correlation |
Previous Message | Josh Berkus | 2011-03-15 00:53:56 | Re: Better estimates of index correlation |