Thread: Re: BUG #4996: postgres.exe memory consumption keeps going up

Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Greg Stark
Date:
Now why did this message get delayed by 4 hours before maia-1
delivered it to me? That was long enough in this to completely lose
the thread of conversation.

Received: from postgresql.org (mail.postgresql.org [200.46.204.86])by maia-1.hub.org (Postfix) with ESMTP id
2909CAFD073;Thu,27 Aug 2009 03:21:19 +0000 (UTC)
 
Received: from localhost (unknown [200.46.208.211])by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486Dfor
<pgsql-bugs-postgresql.org@mail.postgresql.org>;Wed, 26 Aug 2009
 
20:52:17 -0300 (ADT)



-- 
greg
http://mit.edu/~gsstark/resume.pdf


Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Alvaro Herrera
Date:
Greg Stark wrote:
> Now why did this message get delayed by 4 hours before maia-1
> delivered it to me? That was long enough in this to completely lose
> the thread of conversation.
> 
> Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
>     by maia-1.hub.org (Postfix) with ESMTP id 2909CAFD073;
>     Thu, 27 Aug 2009 03:21:19 +0000 (UTC)
> Received: from localhost (unknown [200.46.208.211])
>     by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486D
>     for <pgsql-bugs-postgresql.org@mail.postgresql.org>; Wed, 26 Aug 2009
> 20:52:17 -0300 (ADT)

Moderator delay?  I note that the message jumped to me from mx2.hub.org
instead of maia-1, but at exactly the same time (down to seconds) -- but
at a different time zone.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Magnus Hagander
Date:
2009/8/27 Alvaro Herrera <alvherre@commandprompt.com>:
> Greg Stark wrote:
>> Now why did this message get delayed by 4 hours before maia-1
>> delivered it to me? That was long enough in this to completely lose
>> the thread of conversation.
>>
>> Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
>>       by maia-1.hub.org (Postfix) with ESMTP id 2909CAFD073;
>>       Thu, 27 Aug 2009 03:21:19 +0000 (UTC)
>> Received: from localhost (unknown [200.46.208.211])
>>       by mail.postgresql.org (Postfix) with ESMTP id 0AC3463486D
>>       for <pgsql-bugs-postgresql.org@mail.postgresql.org>; Wed, 26 Aug 2009
>> 20:52:17 -0300 (ADT)
>
> Moderator delay?  I note that the message jumped to me from mx2.hub.org
> instead of maia-1, but at exactly the same time (down to seconds) -- but
> at a different time zone.

Quite likely. It's often not possible to see the difference between
moderation delay and mailsystem breakage delay, without looking at the
logfiles.

It'd be kind of neat of majordomo could insert a "held for moderation
at <time>" and "released from moderation at <time>" headers or
something. Anybody know if that's possible to do?

-- Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/


Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Alvaro Herrera
Date:
Magnus Hagander wrote:

> It'd be kind of neat of majordomo could insert a "held for moderation
> at <time>" and "released from moderation at <time>" headers or
> something. Anybody know if that's possible to do?

You'd need to get Marc to patch the Majordomo2 source code ...
I proposed a patch months ago to have message-ids expanded in the
message footer, but no luck.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Magnus Hagander
Date:
2009/8/27 Alvaro Herrera <alvherre@commandprompt.com>:
> Magnus Hagander wrote:
>
>> It'd be kind of neat of majordomo could insert a "held for moderation
>> at <time>" and "released from moderation at <time>" headers or
>> something. Anybody know if that's possible to do?
>
> You'd need to get Marc to patch the Majordomo2 source code ...
> I proposed a patch months ago to have message-ids expanded in the
> message footer, but no luck.

Did you cook up an actual patch? The majordomo server actually is
something that the community has access to... (it's not properly
documented, of course, but it's there)


-- Magnus HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/


Re: BUG #4996: postgres.exe memory consumption keeps going up

From
Alvaro Herrera
Date:
Magnus Hagander wrote:
> 2009/8/27 Alvaro Herrera <alvherre@commandprompt.com>:
> > Magnus Hagander wrote:
> >
> >> It'd be kind of neat of majordomo could insert a "held for moderation
> >> at <time>" and "released from moderation at <time>" headers or
> >> something. Anybody know if that's possible to do?
> >
> > You'd need to get Marc to patch the Majordomo2 source code ...
> > I proposed a patch months ago to have message-ids expanded in the
> > message footer, but no luck.
>
> Did you cook up an actual patch? The majordomo server actually is
> something that the community has access to... (it's not properly
> documented, of course, but it's there)

Of course; attached.

I have not tried a patch for the feature you propose.  It'd be good to
have those (and also an indication of which moderator approved the
message).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Attachment