public inbox for [email protected]  
help / color / mirror / Atom feed
Cannot submit event
4+ messages / 4 participants
[nested] [flat]

* Cannot submit event
@ 2004-04-20 16:47  Josh Berkus <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2004-04-20 16:47 UTC (permalink / raw)
  To: pgsql-www

Guys,

I've been trying to submit an event for the last 1/2 hour, and it keeps timing 
out.   What's up here?

The event (mostly so I don't lose the text)

PostgreSQL will have a very full track <a 
href="http://conferences.oreilly.com/oscon/">at O'Reilly's OSCON in Portland, 
OR.</a>   If you are in North America, you should not miss this convention -- 
many of the core members of the PostgreSQL community will be there.<br>
(Click header for more details)

---------------------------------------------------------------------
PostgreSQL will have a very full track <a 
href="http://conferences.oreilly.com/oscon/">atO'Reilly's OSCON in Portland, 
OR.</a>   If you are in North America, you should not miss this convention -- 
many of the core members of the PostgreSQL community will be there.<p>
We will have tutorials and presentations by Bruce Momjian, Jan Wieck, Joe 
Conway, Elein Mustain, Greg Mullaine, Vivek Khera, Robert Treat, George 
Essig, Reece Hart, Robert Kaye, Paul Ramsey and Josh Berkus.  There will also 
be a presentation on Advanced SQL from Joe Celko.<p>
We will also have a BOF and possibly additional events in the evening and 
after the convention for the PostgreSQL community.<p>
If you are a listed Major Contributor to PostgreSQL, there is a special 
discount available to attend the convention.  Please contact 
josh--at--postgresql . org to claim this.<p>
A full track listing can be found on <a 
href="http://www.varlena.com/varlena/GeneralBits/70.php">Elein's General 
Bits.</a>

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Cannot submit event
@ 2004-04-21 08:03  Dave Page <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Dave Page @ 2004-04-21 08:03 UTC (permalink / raw)
  To: Josh Berkus <[email protected]>; pgsql-www

 

> -----Original Message-----
> From: Josh Berkus [mailto:[email protected]] 
> Sent: 20 April 2004 17:48
> To: [email protected]
> 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?

Regards, Dave.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Cannot submit event
@ 2004-04-21 09:29  Marc G. Fournier <[email protected]>
  parent: Dave Page <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Marc G. Fournier @ 2004-04-21 09:29 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Josh Berkus <[email protected]>; pgsql-www

On Wed, 21 Apr 2004, Dave Page wrote:

>
>
> > -----Original Message-----
> > From: Josh Berkus [mailto:[email protected]]
> > Sent: 20 April 2004 17:48
> > To: [email protected]
> > 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: [email protected]           Yahoo!: yscrappy              ICQ: 7615664




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Cannot submit event
@ 2004-04-21 10:33  Greg Sabino Mullane <[email protected]>
  parent: Josh Berkus <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Greg Sabino Mullane @ 2004-04-21 10:33 UTC (permalink / raw)
  To: pgsql-www


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
> I've been trying to submit an event for the last 1/2 hour, and it keeps
> timing out.   What's up here?
 
It's obviously not accepting your event because you spelled my name
wrong! :)
 
- --
Greg Sabino Mullane [email protected]
PGP Key: 0x14964AC8 200404210633
 
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFAhk5UvJuQZxSWSsgRAo9dAKD4YrEAGZK6Oj52oNHPeaKmR0GW2gCdEMfS
gdzr2MG5rwiaL1GPhpGlNww=
=58RE
-----END PGP SIGNATURE-----






^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-04-21 10:33 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-20 16:47 Cannot submit event Josh Berkus <[email protected]>
2004-04-21 10:33 ` Greg Sabino Mullane <[email protected]>
2004-04-21 08:03 Re: Cannot submit event Dave Page <[email protected]>
2004-04-21 09:29 ` Marc G. Fournier <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox