Re: IN question

[Steve Atkins <steve(at)blighty(dot)com>]

On Dec 10, 2008, at 2:08 PM, A. Elein Mustain wrote:

> On Wed, Dec 10, 2008 at 01:41:01PM -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.
> >
> > --Josh
>
> I write big, long queries everyday.  I would prefer the
> default be no limit but out of memory.   If you must add
> a limit (why????)  then it should NOT be the default.

Well, one reason for a limit is to provide the DBA with a
last line of defense against idiot clients. Given some of
the dumb things automated query builders and ORMs
are prone to do that's not such a bad idea.

Cheers,
  Steve