Re: IN question

[Jeff Davis <pgsql(at)j-davis(dot)com>]

On Wed, 2008-12-10 at 13:41 -0800, Josh Berkus wrote:
> Steve,
> 
> > I'm not so sure there's such a thing as a limit that's too big. 
> 
> Sure there is.  out-of-memory error.
> 
> Actually, I'd like to see the limit set at work_mem.

You mean that it should share work_mem, or be an additional work_mem
bytes?

I think sharing is probably bad, because then passing a query near the
limit would basically mean that you have no working memory at all (the
query must be parsed/analyzed before other uses of work_mem, of course).
Maybe that's tolerable, I suppose.

And if it's additional memory, it should probably be a different GUC.

If there is an explicit limit, which sounds reasonable, I think it's
good to separate parsing limits from executor limits.

Regards,
	Jeff Davis