Re: tune PostgreSQL using PGADMIN

On Mon, Mar 8, 2021 at 10:39 AM Christophe Pettus <xof(at)thebuild(dot)com> wrote:

>
>
> > On Mar 7, 2021, at 21:04, Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> > There is no such feature. And it is not possible for pgAdmin to change
> PostgreSQL conf as it can be a remote server or if local, can have
> permissions which won't allow pgAdmin to change it.
>
> Note that you can issue ALTER SYSTEM to the PostgreSQL server like you can
> with any client. This isn't specifically a feature of pgAdmin, but you can
> do it from there. Of course, this requires that the user that you are
> using to connect to the PostgreSQL server has the right permissions to do
> an ALTER SYSTEM command.
>
ALTER SYSTEM isn't enough.
Tuning is a lot dependent on the machine/VM configuration, and Most of the
tuning parameters will require the database server to be restarted.
Hence - as per my understanding it is out of scope of pgAdmin.

-- Thanks, Ashesh

>
> Best,
> --
> -- Christophe Pettus
> xof(at)thebuild(dot)com
>
>
>
>