Re: more spamassassin + bayes + postgres stuff

2004-11-19 Thread Michael Parker
[ Lots of Good Stuff ] Yes please, can you dump all of this into the bug so we have a good record. Thanks, Michael pgpy9B04ISWOI.pgp Description: PGP signature

Re: more spamassassin + bayes + postgres stuff

2004-11-19 Thread Rupa Schomaker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oh, forgot something. The patch doesn't create an index on bayes_seen(msgid) -- probably should. - -- -Rupa -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBnY

Re: more spamassassin + bayes + postgres stuff

2004-11-19 Thread Rupa Schomaker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/18/2004 3:38 PM, Michael Parker wrote: > On Thu, Nov 18, 2004 at 06:53:19AM -0800, Rupa Schomaker wrote: > >>Some questions: >> >>Is bytea really necessary? If I follow the path of the patch, the bytea >>change was done prior to adding the ind

Re: more spamassassin + bayes + postgres stuff

2004-11-18 Thread Michael Parker
On Thu, Nov 18, 2004 at 06:53:19AM -0800, Rupa Schomaker wrote: > > Some questions: > > Is bytea really necessary? If I follow the path of the patch, the bytea > change was done prior to adding the index. Since the tokens are binary > data it is probably more correct through, especially if one

Re: more spamassassin + bayes + postgres stuff

2004-11-18 Thread Rupa Schomaker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/17/2004 11:59 PM, Michael Parker wrote: > On Wed, Nov 17, 2004 at 07:15:23PM -0800, Rupa Schomaker wrote: [postgres+spamassassin stuffs] > You should look at Bug 3771: > http://bugzilla.spamassassin.org/show_bug.cgi?id=3771 > and feel free to co

Re: more spamassassin + bayes + postgres stuff

2004-11-18 Thread Michael Parker
On Wed, Nov 17, 2004 at 07:15:23PM -0800, Rupa Schomaker wrote: > > With a bayes_token db of ~125000 entries the system ground to a halt. > Time to look further... > > The sample creation script creates a primary key but no index. Postgres > creates the constraint but not the index to support t

more spamassassin + bayes + postgres stuff

2004-11-18 Thread Rupa Schomaker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 With a bayes_token db of ~125000 entries the system ground to a halt. Time to look further... The sample creation script creates a primary key but no index. Postgres creates the constraint but not the index to support the PK. So, all queries result