Re: Potential performance issues

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
>
>

In response to

Responses

Browse pgsql-performance by date

  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