[ADMIN] Question about access to db server

2012-12-08 Thread T.T Le
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

2012-12-08 Thread Walter Hurry
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

Re: [ADMIN] Question about access to db server

2012-12-08 Thread Cliff Pratt
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

Re: [ADMIN] Question about access to db server

2012-12-08 Thread Mark Mayo
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.