Hello,
We are running PostgresPlus 8.4AS on a linux system. I don't need to edit
the config files or to restart the clusters (the DBA will do that for us).
I only need access to help troubleshoot performance issues with the
databases.
My question is: would pgAdmin be sufficient for what i need to
On Sat, 08 Dec 2012 18:01:06 +, T.T Le wrote:
> Hello,
>
> We are running PostgresPlus 8.4AS on a linux system. I don't need to
> edit the config files or to restart the clusters (the DBA will do that
> for us).
> I only need access to help troubleshoot performance issues with the
> databases
On Sun, Dec 9, 2012 at 7:01 AM, T.T Le wrote:
> Hello,
>
> We are running PostgresPlus 8.4AS on a linux system. I don't need to edit
> the config files or to restart the clusters (the DBA will do that for us). I
> only need access to help troubleshoot performance issues with the databases.
> My qu
Good Evening,
Before tuning the hardware settings I usually execute an EXPLAIN to see the
execution path Postgres uses. A good start to understanding the EXPLAIN
functionality is here http://wiki.postgresql.org/wiki/Using_EXPLAIN .
Since you're using pgAdmin this is a better tutorial
http://www.