Horton

Re: Potential performance issues

MichaelDBA <michaeldba@sqlexec.com>

View thread View on postgr.es
From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: "Jung, Jinho" <jinho.jung@gatech.edu>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-03-01T13:05:39Z
Lists: pgsql-performance 
Ha, Andrew beat me to the punch!

Andrew Dunstan wrote on 3/1/2021 7:59 AM:
> 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
>
>