I have a problem and I would you help me, please. The problem is below:
[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general [Request Too Large:Memory(KB) Exceeded: Requested = 534202, Free = 467356 (Limit = 512412, Used = 45056)]
My tables are like this:
Code: Select all
select * from resource_pools where name='general';
Code: Select all
select * from resource_pool_status where name='general';
I've tried changing the value maxmemorysize to a higher value but I can`t.
When I have tried:
Code: Select all
alter RESOURCE POOL general maxmemorysize '1G'
I have tried with next, as well:
Code: Select all
alter RESOURCE POOL general maxmemorysize '1017216K'
Any idea to help me please?