Re: Maximum length of a query - Mailing list pgsql-general

From Jan Wieck
Subject Re: Maximum length of a query
Date
Msg-id 3E491AB1.2D4153BC@Yahoo.com
Whole thread Raw
In response to Maximum length of a query  ("Matthew V." < <deusmech@yahoo.com>>)
List pgsql-general
Tom Lane wrote:
>
> "Matthew V." <deusmech@yahoo.com> writes:
> > What is the maximum length of a query nowadays? Back in 1998, it was 8192
> > bytes,
>
> That was a long time ago ;-).  There has been no hard-wired upper limit
> for several releases now.
>
> [ It's rather amusing to watch MySQL's crashme test trying to discover
> our maximum query length.  At least on my machine, the Perl process
> running crashme hits the kernel's per-process memory limit and dies,
> while the backend it's talking to is still comfortably under the limit.
> I wonder whether MySQL regards that as a test failure ... ]

Well, it's our fault anyway. You cannot have a hardcoded limit in one
release and then, all of the sudden, out of nowhere go unlimited ... one
can claim that we crash crashme on purpose! OTOH, isn't that what the
name asks for?

I have to apologize at this point ... I did the same with TOAST ...
going unlimited without fair warning. Fortunately crashme never tested
for a maximum content length ;-)


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: starting out
Next
From: Greg Stark
Date:
Subject: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3