[ADMIN] Postmaster taking up 100% of CPU

Hi,everyone The CPU of my linux box is 100% by postmaster processes for hours. How to deal with it? The following is my top log and ps log: PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 8970 postgres 16 0 53692 36m 34m R 27.3 3.6 1:14.80 postmaster 8807 postgres

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

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/8.4/etc/postgresql directory. Just cre

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

Excerpts from Balkrishna Sharma's message of lun jul 05 13:00:44 -0400 2010: > > I know that we can toggle the timing at session level by using \timing in > psql. > Is there a way to set the default to 'timing on' globally across the database > or atleast across all psql statements by a specific

[ADMIN] Change to 'timing on' globally

I know that we can toggle the timing at session level by using \timing in psql. Is there a way to set the default to 'timing on' globally across the database or atleast across all psql statements by a specificied user ? Thanks,-Bala __

Re: [ADMIN] Zip file for windows 8.4.4 binary

On 05/07/10 10:46 AM, Walter Willmertinger wrote: Does anybody know how to get the binary for windows? When I follow the link on postgresql.org , on the page: http://www.postgresql.org/download/windows ... /Advanced users/ can also download a zip archive

Re: [ADMIN] Zip file for windows 8.4.4 binary

Ok, I noticed it! Thank you for your advice! MfG Walter Willmertinger On Mon, Jul 5, 2010 at 12:16 PM, Thomas Kellerer wrote: > Walter Willmertinger, 05.07.2010 11:46: > >> *Advanced users* can also download a zip >> archive of >> >> the

Re: [ADMIN] Zip file for windows 8.4.4 binary

Walter Willmertinger, 05.07.2010 11:46: *Advanced users* can also download a zip archive of the binaries, without the installer. That page *does* contain the zip files It says "Binaries from installer version 8.4.4-1" right above the "down

[ADMIN] Zip file for windows 8.4.4 binary

Does anybody know how to get the binary for windows? When I follow the link on postgresql.org, on the page: http://www.postgresql.org/download/windows ... *Advanced users* can also download a zip archive of the binaries, without the installer.