On Tue, Mar 15, 2011 at 05:09:47PM +0100, Pavel Stehule wrote:
> Real test of parser's speed should be done on short and quick queries.
> It can be unexpected so parser should be a bottle neck on long OLAP
> queries.
Surely parsing overhead could be measured by simply PREPAREing every
query, rathe
2011/3/15 Robert Haas :
> On Tue, Mar 15, 2011 at 2:19 AM, Pavel Stehule
> wrote:
>> 2011/3/15 Robert Haas :
>>> On Mon, Mar 14, 2011 at 4:34 PM, Tom Lane wrote:
Pavel Stehule writes:
> there was a discussion about impact of number of keyword for parser
> speed. I did some syntheti
On Tue, Mar 15, 2011 at 2:19 AM, Pavel Stehule wrote:
> 2011/3/15 Robert Haas :
>> On Mon, Mar 14, 2011 at 4:34 PM, Tom Lane wrote:
>>> Pavel Stehule 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 slown
2011/3/15 Robert Haas :
> On Mon, Mar 14, 2011 at 4:34 PM, Tom Lane wrote:
>> Pavel Stehule 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.
>>
On Mon, Mar 14, 2011 at 4:34 PM, Tom Lane wrote:
> Pavel Stehule 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 re
On 3/14/11 1:34 PM, Tom Lane wrote:
> Pavel Stehule 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 suppo
Pavel Stehule 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
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
