[ADMIN] Invitation to connect on LinkedIn

2010-07-06 Thread Gourish Singbal
LinkedIn Gourish Singbal requested to add you as a connection on LinkedIn: -- Arthur, I'd like to add you to my professional network on LinkedIn. - Gourish Accept invitation from Gourish Singbal http://www.linkedin.com/e/d1pxbl-gbbslet9-13/k_L

Re: [ADMIN] Change to 'timing on' globally

2010-07-06 Thread Bruce Momjian
Balkrishna Sharma wrote: > > > I just tested it here on Ubuntu and it worked:I followed your steps and it > > worked in the way you indicated, on CentOS as well. But it still does > > not:a. work with psql -c "query" syntax. (Works in echo mode or in > > interactive mode.)b. it does not still

Re: [ADMIN] Change to 'timing on' globally

2010-07-06 Thread Balkrishna Sharma
> I just tested it here on Ubuntu and it worked:I followed your steps and it > worked in the way you indicated, on CentOS as well. But it still does not:a. > work with psql -c "query" syntax. (Works in echo mode or in interactive > mode.)b. it does not still seem to work if you fire the querie

Re: [ADMIN] Change to 'timing on' globally

2010-07-06 Thread Bruce Momjian
Balkrishna Sharma wrote: > > Thanks. If I want to do at system-wide level, where do I store the > psqlrc file (assuming I want to change the timing behavior system-wide)? > (CentOS 5, Postgres 8.4) > $ ./pg_config --sysconfdir/opt/PostgreSQL/8.4/etc/postgresql > But I don't have /opt/PostgreSQL/

Re: [ADMIN] Postmaster taking up 100% of CPU

2010-07-06 Thread Greg Smith
higeon wrote: The following is my top log and ps log: Try using "top -c" on Linux instead. Then you'll be able to see what all the processes are doing. Any heavy query will cause a CPU to consume 100% of its time when running, so there may be nothing wrong other than you have queries to op