From josh@agliodbs.com Fri Jun 5 23:48:41 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id ACEEDD1E143 for ; Tue, 20 Apr 2004 22:49:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16746-05 for ; Tue, 20 Apr 2004 22:49:44 -0300 (ADT) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 8DA45D1F380 for ; Tue, 20 Apr 2004 13:48:10 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 4907873 for pgsql-www@postgresql.org; Tue, 20 Apr 2004 09:49:32 -0700 Content-Type: text/plain; charset="us-ascii" From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-www@postgresql.org Subject: Cannot submit event Date: Tue, 20 Apr 2004 09:47:49 -0700 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200404200947.49476.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/175 X-Sequence-Number: 4279 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 at O'Reilly's OSCON in Portland, OR. If you are in North America, you should not miss this convention -- many of the core members of the PostgreSQL community will be there.
(Click header for more details) --------------------------------------------------------------------- PostgreSQL will have a very full track atO'Reilly's OSCON in Portland, OR. If you are in North America, you should not miss this convention -- many of the core members of the PostgreSQL community will be there.

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.

We will also have a BOF and possibly additional events in the evening and after the convention for the PostgreSQL community.

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.

A full track listing can be found on Elein's General Bits. -- Josh Berkus Aglio Database Solutions San Francisco From dpage@vale-housing.co.uk Fri Jun 5 23:48:25 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AEB5AD1D137 for ; Wed, 21 Apr 2004 05:03:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44898-02 for ; Wed, 21 Apr 2004 05:03:40 -0300 (ADT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 77602D1BB36 for ; Wed, 21 Apr 2004 05:03:38 -0300 (ADT) Received: from mailgate.vale-housing.co.uk ([80.176.1.146] helo=salem.vale-housing.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 1BGChn-000JyY-0V; Wed, 21 Apr 2004 09:03:39 +0100 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Subject: Re: Cannot submit event Date: Wed, 21 Apr 2004 09:03:39 +0100 Message-ID: <03AF4E498C591348A42FC93DEA9661B889FADB@mail.vale-housing.co.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Cannot submit event Thread-Index: AcQnQy75I7MrcX11Qvi8crEJ+kDUtgAM9fGw From: "Dave Page" To: "Josh Berkus" , X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/181 X-Sequence-Number: 4285 =20 > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com]=20 > Sent: 20 April 2004 17:48 > To: pgsql-www@postgresql.org > Subject: [pgsql-www] Cannot submit event >=20 > Guys, >=20 > I've been trying to submit an event for the last 1/2 hour,=20 > and it keeps timing=20 > 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. From scrappy@postgresql.org Fri Jun 5 23:48:25 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5C433D1B974 for ; Wed, 21 Apr 2004 06:29:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 72435-05 for ; Wed, 21 Apr 2004 06:29:21 -0300 (ADT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 6AEE3D1B967 for ; Wed, 21 Apr 2004 06:29:19 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 6360A34270; Wed, 21 Apr 2004 06:29:22 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 6070633E38; Wed, 21 Apr 2004 06:29:22 -0300 (ADT) Date: Wed, 21 Apr 2004 06:29:22 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: Dave Page Cc: Josh Berkus , pgsql-www@postgresql.org Subject: Re: Cannot submit event In-Reply-To: <03AF4E498C591348A42FC93DEA9661B889FADB@mail.vale-housing.co.uk> Message-ID: <20040421062534.I32445@ganymede.hub.org> References: <03AF4E498C591348A42FC93DEA9661B889FADB@mail.vale-housing.co.uk> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/183 X-Sequence-Number: 4287 On Wed, 21 Apr 2004, Dave Page wrote: > > > > -----Original Message----- > > From: Josh Berkus [mailto:josh@agliodbs.com] > > Sent: 20 April 2004 17:48 > > To: pgsql-www@postgresql.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@hub.org Yahoo!: yscrappy ICQ: 7615664 From greg@turnstep.com Fri Jun 5 23:48:41 2026 X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6324ED1DB0D for ; Wed, 21 Apr 2004 07:33:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95880-08 for ; Wed, 21 Apr 2004 07:33:31 -0300 (ADT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 165DAD1D7FB for ; Wed, 21 Apr 2004 07:33:28 -0300 (ADT) Received: (qmail 12176 invoked from network); 21 Apr 2004 10:33:31 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 21 Apr 2004 10:33:31 -0000 From: "Greg Sabino Mullane" To: pgsql-www@postgresql.org Subject: Re: Cannot submit event X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <200404200947.49476.josh@agliodbs.com> Date: Wed, 21 Apr 2004 10:33:31 -0000 X-Mailer: JoyMail 1.47 Message-ID: <69da716872c0bbcedebe9b04890b7534@biglumber.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200404/184 X-Sequence-Number: 4288 -----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 greg@turnstep.com PGP Key: 0x14964AC8 200404210633 -----BEGIN PGP SIGNATURE----- iD8DBQFAhk5UvJuQZxSWSsgRAo9dAKD4YrEAGZK6Oj52oNHPeaKmR0GW2gCdEMfS gdzr2MG5rwiaL1GPhpGlNww= =58RE -----END PGP SIGNATURE-----