On Tue, May 30, 2006 at 03:40:28PM -0400, Andrew Sullivan wrote:
> On Tue, May 30, 2006 at 12:29:41PM -0700, Wayne Conrad wrote:
> > has a "where log_actionseq not in (...)" clause with about 320,000
> > numbers in it, which is what is making postgres cranky.
> 
> Sort of.  If I'm not mistaken, that setting is in the postgresql.conf
> file, and it's measured in KB.  You can increase it.  I believe it
> requires a restart of the postmaster to take effect, but check
> the docs.

Thanks for mentioning that, since I forgot to.  That's
max_stack_depth, which defaults to 2048KB.  I increased it to 4098KB,
then 8192KB, and so on.  When I got to 1048576K with no success, I
decided that dog wasn't gonna hunt.  Does it make any sense to try
more than 1GB of stack?