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? _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
