Category: PostgreSQL General List


Article: Postgres mail list traffic over time



57 items found, displaying 1 to 5.[First/Prev] 1, 2, 3, 4, 5, 6, 7, 8 [Next/Last]
Id date Message
2008-12-02 14:54:51.0 I got interested by Bruce's plot of PG email traffic here
http://momjian.us/main/img/pgincoming.gif
and decided to try to extend it into the past. The data I have
available is just my own incoming mail log, but being a pack-rat by
nature I have that back to April 1998. Attached is a graph of Postgres
list messages per month since then. I should note that this covers only
the mail lists I'm subscribed to, which has been most of them since
about 1999; but the first few numbers in this chart are undercounts by
comparison. Also, the very last dot is month-to-date for November and
so is an underestimate.

So, to a first approximation, the PG list traffic has been constant
since 2000. Not the result I expected.

regards, tom lane

â?°PNG


IHDRâ?¬àªáI.tEXtSoftwaregnuplot Unix version 3.7 patchlevel 04Â¥Å?

qIDATxÅ?í�MoÃ?Ã?}ªnÃ?¨a}â??
¤FãÃ?Ã?¡@M â?¡lO`(vÃ?Ã?²àÃ?žC¹EÃ?â?¬s*Tx0bµ â�â??Æ?NBNÅ? *Ã?¶ Å?T$Fu:\îLwvgvgg_æíq+Ã?ûVÅ?åòÃ?ÿ<3;/Ã? W(°]èâ?¬°ž5àò*�Ã?¿1�+o:ã0
üjãwÃ?>Ã?|�üðÃ?Sú³K/ÿ{ü9yøKôlüñO>r.Ã?Ã?Žö¬SOçôÃ?qDÃ?FË?¼»�'£â?¡Â·Å?Fâ?¹Fxeâ?¢Ã?§ ðµ+7Ÿî�oJ'£Ã?áÃ?
Ë?ïîc4%1â?¢Ã?k4Ã?^ #ònÃ?â?¬_ºâ??ïÃ?Ã?ðâ?¡Â«Ã?�E´wñòÃ?Ã?�â?¡oÃ?Ã?xpâd6â??'iâ?°Â·â?º8â??§@këâ?¬Ã? ¸Ã?8믳FÃ?7Gúëlâ?¬ï¿½Ã?öA�Ã?Ã?7â? Ã¤Å?­¤
]Ã?%I§�c:Â¥(=D4$4=Ë?Ã?Iâ??ŸNÃ?�òâ?¦Ã©â?¢Ã¬Ã?¹ð!(�â?¢r¹QBrÃ?â?°PNâ??Ã?Ã?¹8fõð¼Ã?­vÃ?Ã?;`´Ã?Ã?Ã?4pâ? â?¬ï¿½Ã 
Ã?}Ã?l°vÃ?â??DÃ?@â??��q WîÃ?V;'Ã?â??Ã?é­'�¦pHàúÃ?>(�Ã?n Ã?
�¤AÅ?ø9 bÃ?XÃ?Ë?û0z]Ã?ô¬WìøÿÃ?Ã?¯ý�GÃ?Ã?¡;Ã?žuWÃ?Ã?Ã?¹û°µGvÅ?a�Ã?@Ã?Ã?Ë?¡�Z;Ã?Ã?94ð8â??â??+ô÷aXOu¦÷!öÃ?!(Ã?[aÃ?\Ã?
f
HòvÃ?(Å?â??èâ?¢b'VÃ?]`Ã?w*Q+C`)Weâ?¦"®6µâ??üž].|(îù)LOJGJ·¬â?¬ÂµÃ¯.Jëpv
â?¦Er"ñÃ?^â??²óaÃ?�?Ÿ(Ã?R·õÃ?'ù«D[Ã?½#õ
;à¼P¸â?¢dA§Ã?Ã?%VÃ?£Ã?â?¡{Iö'z*â??ôLâ??ì/Ã?H9+â??³¼
Ã?Ã?FKÃ?â?°"ûbÃ?Ë?­�ªMÃ?
/ ¢ùÃ?Ã?^>Ã?Ã?fôâ?¢5z�a®j«8Ã?îö\al;¸Ã?Å ;/fíÃ?è{» Ã?Ã?Hn¢=Ã?â6·-Æ?LÃ?},Ÿâ?¢Ã?çÃ?%íÃ?°0Ã?*O1òŽ@Ã?â?°aa¬Fâ??'AùòEÃ?N �¥zPí[nõ°yÃ?Ã?Ã?¼àãl^ðiFJºqÆ? )p¦¤÷j®±Nâ??ôVÃ?5VÃ?â?¢â??ç/}�â??Å?ç~Å?<�¥<Ã?jF8Ã?@Yá¤aâ??£Ã?Ã?�²güšJÃ?)Ã?Ã?Ã?+¶â?¬Wêâ?º `ê¾g©RwË?Ã?â?¬Å >Ã?XQòîiË?Ã?â?¬ÂµÃ·S8Ã?nÃ?²¡ìcÃ? â??#CYn¬i³â{AP¤�Pâ? Ã¼Â£ÃºÃ¶Ã¢Ã?52¤Цâ?¢â?¢Ã?_Pññ}¨»Ã?EçÃ?êÃ?¯Ã?W¡<¨#iq¨[òL²Ã?ù'é«~9 )¾Ã?(|¸wñF G+Ã?àÃ?½cXÃ?Ã?¡hxúÃ?°Ã?RanG¢i k¾Ã?8W;¬Ã? M+¶Ã?Â¥zMÃ?Xnsæ¥â??NÃ?r«(U$W`¹Ã?¶òOâ? Å Ã?¢Ã?ù'ûŠâ?¹Ã?Ã??Ã?«|O�pq:Ã?{gW²C ¿!4[â??rLµÃ?wUË?Nâ?¢x¾K
CWàì.%Æ?«ï/â?¦5#Ã?~hmäO:(¬š< uðaÃ?Ã?ec j8)eS`ãâ??â?¢Ã²Ã?¹áNÅ?Ã?=ur47Ã?E ),·\j�Ã?ìÃ?@ù«rÃ?ªÃ?Ã?Ã?â?¡Å¸Ã?1Zg|YÆ?¶1ísRâ?? â? pSË?ýiŸ5â?º1DAÅ &i�Ã?T Ã?¹BÃ?(·nªjù!÷!WÃ?¾Ã?Ã?$}ª6òÃ?â?¡Å¾
kÅ 91?Ë?.Å?â?¬Ã?X5þ Ã?þÃ?â??D �â?°I>Ã¥i3Ã?,µâ?¡F
yÃ?m4ò¡�B#3õ¡¦Ã?UL 57â? 5°o²?$·XìY)\Ë?(´ña2½Ã?qhN£&
�­çEZ�
b ¯ª¬i7V¨®tÃ?YÃ?ùLu>,&â? ï¿½>â?¢(Ã?Ã?Ã?)bbË?õ
£,Ã?¡1�6bþ·Ea¨(l·â?¬Ã¿mñ¡4â??Ã?[Qš�êüÃ?La P»ªdX «â?ºX[)5Ã?Ã?W¿yÃ?(j`,î )j Eâ??Ã?â??n]í]lâ??â??u�Ã?Bhâ?¦Ã½VÃ?¾l·t¸¯U¡â?¹ÂµÃºÃ?â?° ìC{g^axâ? Â¢Ã? í½Hîÿ"® b´¬šë�QÃ?N ¶4Æ?ìyYãÃ?Ã?«AÅ?dtk9þâ??Ã?.Å?öâ?¡7kJ9Ã?MÃ?[�´¾"â?¡ÃªÂ©Â«Ã?YãÃ?³îÃ?bì`¦Ã?bh§â??ô< Ã?Lb4îãM�£3 mE</-vüqïÃ?600î�uâ?¦Ã ><Ã?¦vÃ?Ã?;à�hº'Ã?hºkÃ?¨îdpæ' æó Ã?.úÃ?Ã?xd`í¶Ã?� ¤�k¶v8VÃ?,ncûûâ??f3Ã?Ã?ae&[;ì�Ã?¿OÃ?â?¢uÃ?Whò+ í>-Ã?ä8V@pâ?¦Ã >t³Ã?;`ìâ?¬Â­@£=16Ã?# Ã?Ã?â?°Ã?n=pâ? :-¶�1Ã?â?¬Ã 
]â??Ã?�îÃ?_Ã?..`´â?¹\íb+*°fzë§°fîéÃ?º â? p Ã?Ë?Ã?üâ??BáŸKÃ?á½üj140Ã?mÃ?5â??+â??÷¡ŸÃ?Ã?"-@·�M�5þnAÂ¥ ëž@N"`Ã?Å?{Ã?`äÃ?Ã?7Ã?ûø& sÃ?ô³ÿ
Ã?^Å?{�â?¹Ã¬Ã?2pÃ?Ã?o,pñWw^½=Ã?â? ÃºRöh^v=tÃ?âÃ?lytâ?¢0û paúÃ?-S`\}¼Ž�B+Ã?Nâ?? @jû£0`®0â??"Å?d¨Gâ??ª
d]¼G­
dÆ?pâ?¦ >$üaø
B$àRš�# )žêëB,þ��o!gA R1�BûP
UùtÃ?�ú j�Sžz ¸BpzÃ?¹z»Pz² ½«¡ìâ?º<OÃ?Ã?3yžª
°ï¸¯úLÃ?êâ?¬ÂµQ"oZèÃ?ú«@Ã?þ©Wè± Ã?Å?`àüâ??Â¥Uà$Ã?00b4'}ç¡ ï,¯ô�â?¡Vâ?¬Ã 
Ã?}c°vÃ?hDrÃ?â?°PN¨Ã?�~â?¢Ã?14pÃ?Zl'â?? ôÃ?�Ã?ô N³gâ??#qâ? â??/LÃ?d
à>4pH.��
îR8�|
C!íâ? â??® S1¸Ã?Ã?¼tõâ?¦}Žw6Wâ??÷xât¼3%oñÃ?â?¹Ã?ñ7te Å?¢â?º8><>Ã?7¿áWÃ?�Ã?í?òÃ?h°>=ø;OÅ?Å?_Ã?óâ?ºÂ£Ã°Ã»dû¨¢;WsàáñÃ?â??oâ?¦Ã?èúîGëââ?°Ã¸Ã?;Ã?Ã?¯xâ??ì?ê�Ь­íãâ??/8�>^Ã?Ã?)â? Â¯]¼7Ã?³|íâ??·g8Ã?ê­Ã?â<nÃ?úìmâ??Ã¥Ã?ðÆ?Ã?¾Ã?òíãiON_ ~cmô\Ã?o�pºû`åýCâ??å¯wOnâ?°,?¿>
!Ã?Ã?öI\?>Ë?çÃ?Ã?zÃ¥Ã?Ã?à$Ã?�â?°GïO0ñ(¾S7Ã?z�ŠÃ?ïÃ?¬â??OyâéÃ?â?¡Â¯/7x⟬â??¯pÃ?w¿ïÃ?KWyþ/³R^Ã?� Ã?; Æ?ýl(qFã8Ã?BIEND®B`â??

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008-11-20 21:52:14.0
183090 2008-11-20 21:52:14.0 Tom Lane wrote:
> I got interested by Bruce's plot of PG email traffic here
> http://momjian.us/main/img/pgincoming.gif
> and decided to try to extend it into the past. The data I have
> available is just my own incoming mail log, but being a pack-rat by
> nature I have that back to April 1998. Attached is a graph of Postgres
> list messages per month since then. I should note that this covers only
> the mail lists I'm subscribed to, which has been most of them since
> about 1999; but the first few numbers in this chart are undercounts by
> comparison. Also, the very last dot is month-to-date for November and
> so is an underestimate.
>
> So, to a first approximation, the PG list traffic has been constant
> since 2000. Not the result I expected.

Yes, I know Magnus did a graph for the PG-EU conference and it was also
flat; perhaps he can post it here. His chart was pulled from the
Postgres archives, so it is even more accurate than our graphs.

I also was confused by its flatness. I am finding the email traffic
almost impossible to continue tracking, so something different is
happening, but it seems it is not volume-related. I am going to post
another blog tomorrow with more thoughts.

--
Bruce Momjian <noway@spam.com> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
183095 2008-11-20 22:04:39.0 Bruce Momjian <noway@spam.com> writes:
> Tom Lane wrote:
>> So, to a first approximation, the PG list traffic has been constant
>> since 2000. Not the result I expected.

> I also was confused by its flatness. I am finding the email traffic
> almost impossible to continue tracking, so something different is
> happening, but it seems it is not volume-related.

Yes, my perception also is that it's getting harder and harder to keep
up with the list traffic; so something is happening that a simple
volume count doesn't capture.

Does anyone have the data to break it down per mailing list? That might
yield some more insight.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
183097 2008-11-20 22:10:51.0 Tom Lane wrote:
> Bruce Momjian <noway@spam.com> writes:
> > Tom Lane wrote:
> >> So, to a first approximation, the PG list traffic has been constant
> >> since 2000. Not the result I expected.
>
> > I also was confused by its flatness. I am finding the email traffic
> > almost impossible to continue tracking, so something different is
> > happening, but it seems it is not volume-related.
>
> Yes, my perception also is that it's getting harder and harder to keep
> up with the list traffic; so something is happening that a simple
> volume count doesn't capture.

Agreed. I am struggling to put into words some of my angst, but I am
concerned I will not be able to offer the same guarantees I have done in
previous releases that every bug has been either fixed or added to the
TODO list, and every submitted patch has been either applied or rejected.

There, I said it. :-(

--
Bruce Momjian <noway@spam.com> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-general mailing list (pgsql-noway@spam.com)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Questions or comments? Feel free to post them here. No login or id required.

Valid XHTML 1.0!
Site Map >>