[tag=RB | □]
[tag=RB | □=□]
[tag=RB | !□]
Another solution is not to use dynamic loading , but to link your functions into the backend statically and declare them as INTERNAL functions . Ideally , the above tasks should be done by a shell script that is run nightly or weekly by cron . We recommend that active production databases be cleaned nightly , in order to keep statistics relatively current . It was just right , and Goldilocks fell asleep . Incorrect use of an optimization clause can result in backend crashes , subtly wrong output , or other Bad Things . Although the minimum required memory for running Postgres is as little as 8MB , there are noticable improvements in runtimes for the regression tests when expanding memory up to 96MB on a relatively fast dual-processor system running X-Windows .