The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Too many open files issue
Getting an error "Too many open files issue" error messages. This can occur when some of the tables being referenced in the analyze_constraints(), had a large number of delete vector containers. It can also occur when an update is trying to run Insufficient resources to execute plan on pool general [Request Too Large:File Handles Exceeded: Requested = 54262, Free = 54227 (Limit = 54227, Used = 0)]