Skip site navigation (1) Skip section navigation (2)

Re: Cannot submit event

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-www(at)postgresql(dot)org
Subject: Re: Cannot submit event
Date: 2004-04-21 09:29:22
Message-ID: 20040421062534.I32445@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-www
On Wed, 21 Apr 2004, Dave Page wrote:

>
>
> > -----Original Message-----
> > From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
> > Sent: 20 April 2004 17:48
> > To: pgsql-www(at)postgresql(dot)org
> > Subject: [pgsql-www] Cannot submit event
> >
> > Guys,
> >
> > I've been trying to submit an event for the last 1/2 hour,
> > and it keeps timing
> > out.   What's up here?
>
> Dunno, I'm just fixing the bug that Bruce found in the events archive
> and the database is insufferably slow. Any ideas Marc?

Beyond the fact that there is an atrocious amount of connections opened
up:

neptune# ps aux | grep 186_ | awk '{print $12}' | sort | uniq -c
   1 186_
   3 186_bric
  27 186_gborg
 104 186_pgsql

nadda ... loadavg is <1 on the database server, and I have pg_autovacuum
enabled to keep tables 'clean' ... does anyone know of a way of having
pg_autovacuum log the database its doing the vacuum on, instead of just
schema.table ... I'm seeing an awful lot of vacuum's of pg_statistic, but
have no idea which database:

[2004-04-21 12:32:29 AM] Performing: VACUUM ANALYZE "public"."siteusers"
[2004-04-21 12:34:09 AM] Performing: VACUUM ANALYZE "pg_catalog"."pg_statistic"
[2004-04-21 12:34:11 AM] Performing: VACUUM ANALYZE "pg_catalog"."pg_statistic"
[2004-04-21 12:34:13 AM] Performing: VACUUM ANALYZE "pg_catalog"."pg_statistic"
[2004-04-21 12:34:15 AM] Performing: VACUUM ANALYZE "pg_catalog"."pg_statistic"
[2004-04-21 08:48:20 AM] Performing: VACUUM ANALYZE "public"."siteusers"


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

In response to

pgsql-www by date

Next:From: Greg Sabino MullaneDate: 2004-04-21 10:33:31
Subject: Re: Cannot submit event
Previous:From: Dave PageDate: 2004-04-21 08:12:54
Subject: Re: Events archive broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group