[ADMIN] Question about access to db server

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

Re: [ADMIN] Question about access to db server

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

Re: [ADMIN] Question about access to db server

On Sun, Dec 9, 2012 at 7:01 AM, T.T Le lotus.sign...@gmail.com 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

Re: [ADMIN] Question about access to db server

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