I wish I could see those hanging queries, what SQL do they try to execute:
pref= select * from pg_stat_activity;
datid | datname | procpid | usesysid | usename |current_query
| query_start | backend_start | client_addr |
client_port
Dear Farber,
Is there anything that stops you from upgrading to a more respectable
release number?
Eg 9.0 or at least latest 8.4.X
Regds
Rajesh Kumar Mallah.
Hello again,
ouch, I have these postmaster's spinning up again -
even though I've disabled the cronjob and rebooted:
top - 11:42:31 up 1:22, 2 users, load average: 9.15, 7.59, 5.03
Tasks: 135 total, 10 running, 125 sleeping, 0 stopped, 0 zombie
Cpu0 : 31.7%us, 0.5%sy, 0.0%ni, 67.4%id,
Alexander Farber skrev 2010-10-04 11.48:
I wish I could see those hanging queries, what SQL do they try to execute:
To see the query you need to enable stats_command_string in your
postgresql.conf. See:
http://www.postgresql.org/docs/8.1/interactive/runtime-config-statistics.html
You
On 4/10/2010 5:20 PM, Alexander Farber wrote:
# rpm -qa | grep -i postgres
postgresql-8.1.21-1.el5_5.1
Mmm, elderly.
On Friday I've installed a cronjob (full source code at the bottom):
3 3 * * * psql -a -f
$HOME/bin/clean-phpbb-forum.sql
Do you rate-control
I've upgraded my CentOS 5.5 VM to:
postgresql-libs-8.4.4-1PGDG.rhel5
postgresql-devel-8.4.4-1PGDG.rhel5
postgresql-8.4.4-1PGDG.rhel5
postgresql-contrib-8.4.4-1PGDG.rhel5
postgresql-docs-8.4.4-1PGDG.rhel5
postgresql-server-8.4.4-1PGDG.rhel5
postgresql-plperl-8.4.4-1PGDG.rhel5
and then have loaded
Hello Postgres users,
I have a Linux website with phpBB serving a small Facebook game:
# uname -a
Linux X 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010
x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
CentOS release 5.5 (Final)
# rpm -qa | grep -i postgres
Alexander Farber skrev 2010-10-04 11.20:
Hello Postgres users,
I have a Linux website with phpBB serving a small Facebook game:
# uname -a
Linux X 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010
x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/redhat-release
CentOS release 5.5 (Final)
#
Thank you, I've enabled logging,
but couldn't see anything suspicious there.
Also the 60%-120% CPU-eating postmaster
processes are now suddenly gone.
I suspect this is some bug in the
postgresql-server-8.1.21-1.el5_5.1 delivered
with CenOS 5.5/64 bit, because I don't
have many simultaneous users
Specifically look into setting.
log_min_duration_statement (integer)
in the postgresql.conf file.
-Original Message-
From: Robert Gravsjö [mailto:tekniksupp...@blogg.se]
Sent: Monday, October 04, 2010 7:22 AM
To: Alexander Farber
Cc: pgsql-general@postgresql.org
Subject: Re: Any
10 matches
Mail list logo