On Fri, 7 May 2010 08:38:17 -0500 Kenneth Marshall <k...@rice.edu> wrote:
> On Fri, May 07, 2010 at 04:11:50PM +0300, Ion-Mihai Tetcu wrote: > > On Fri, 7 May 2010 00:32:14 +0200 > > Stevan Baji?? <ste...@bajic.ch> wrote: > > > > > > > > Btw, I'm stas on irc in #dspam. Lurking most of the time, maybe > > > > > > I should ask there if somebody hangs on irc? > > > > > > > > > > > Ion-Mihai is hanging there. And he is sure already sharpening his > > > > > Release Manager knife to kill me because I am purposing changes > > > > > for DSPAM :) > > > > No, no :) I could kill you for "fix a bug" commit logs, but given that > > you are the one that fixes them, I don't dare :) > > > > I should have the cattle-prod used on me for various reasons. (I'll > > reply to your private mail about this later today, hopefully). > > > > > > Yep, had a chat this afternoon with ITetcu, he encouraged me to ask > > > > on mailing list :) > > > > > > > Mailing list is often better because your question gets exposed to > > > more users at once. And beside that the communication on the mailing > > > list is mirrored and saved at many places. > > > > Indeed. Also mails then to be more clear (I misunderstood a bit what > > Stas asked me on IRC). > > > Hi DSPAM community, > > For myself, I really appreciate having the conversations about problems > and solutions with DSPAM being carried out on the mailing list. It allows > me to save a personal copy of key messages and provides a historical > archive to search for answers. IRC conversations are only known to those > who happened to be on-line at the time and then there is no record. > > Steve and Ion, I would like to thank you for all the hard work you have put > into the DSPAM project. We are going to be upgrading our DSPAM infrastructure > over the summer to version 3.9.0+ and hopefully switch from a MySQL backend > to a PostgreSQL backend. As a start I have built 3.9.0 on a Solaris 8 box > against PostgreSQL 8.4.2. My current project is to allow for an option to > have the PostgreSQL driver use out-of-band binary transmission of query > parameters. This will have two benefits. First, less CPU will be used since > the atoi() calls will not be needed to send the data. Second, the size of > the transmitted data will be reduced by 70% or more in the worst case of > looking up the tokens. This is more important when the DSPAM DB is on a > separate machine from the actual engine. > > The first cut will be using the libpqtypes.h library to do the work. > Then I will do some comparisons between the binary transmission and > the current non-binary transmission of the query parameters. Is this > something that you would be interested in having folded back in to > the DSPAM codebase? > A big YES from me. > Regards, > Ken > ------------------------------------------------------------------------------ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
