...
Code Block |
---|
|
export PGPORT=5430
export PGHOST=127.0.0.1
export PGDATABASE=madlibtest
$BUILD_ROOT/src/bin/madpack -p postgres install |
Anchor |
---|
| GPDB Variables |
---|
| GPDB Variables |
---|
|
Defining GPDB variablesThe variables below can be set in GPDB in case memory-related issues show up. Feel free to adjust them based on the specifics of the installed system.
Code Block |
---|
|
set max_statement_mem='50GB';
set statement_mem='50GB';
set memory_spill_ratio=80;
set gp_resqueue_memory_policy=auto;
set work_mem='4GB';
set gp_vmem_protect_limit=20000 |
Anchor |
---|
| Upgrading MADlib gppkg |
---|
| Upgrading MADlib gppkg |
---|
|
Upgrading MADlib gppkg
...