On 2/28/21 10:04 AM, Jung, Jinho wrote: > # install DBMS > sudo su > make install > adduser postgres > rm -rf /usr/local/pgsql/data > mkdir /usr/local/pgsql/data > chown -R postgres /usr/local/pgsql/data > su - postgres > /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data > /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start > /usr/local/pgsql/bin/createdb jjung Using an untuned Postgres is fairly useless for a performance test. Out of the box, shared_buffers and work_mem are too low for almost all situations, and many other settings can also usually be improved. The default settings are deliberately very conservative. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
