| From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | "Jung, Jinho" <jinho(dot)jung(at)gatech(dot)edu>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Potential performance issues |
| Date: | 2021-03-01 13:05:39 |
| Message-ID: | 42887432-d6b9-355d-5fc3-913b19560a26@sqlexec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Jolliffe | 2021-03-01 13:44:38 | Re: Potential performance issues |
| Previous Message | MichaelDBA | 2021-03-01 13:04:19 | Re: Potential performance issues |