Re: [Dbmail-dev] Missing postgres index

2004-05-31 Thread Aaron Stone
So people looking for their INBOX end up forcing a full table scan to find out when lower( name ) = lower( 'INBOX' ), when in fact 99% of the time, the value of column name => "INBOX" anyways. Changing the query from lower( '%s' ) to lower( 'inbox' ) is basically a micro-optimization because INBOX

Re: [Dbmail-dev] broken auth/authldap.c

2004-05-31 Thread Aaron Stone
Fixed in CVS. Thanks for the heads up! I must have scared Ilja away with my GETCONFIGVALUE macro ;-) Aaron Paul J Stevens <[EMAIL PROTECTED]> said: > > compiling --with-auth-ldap fails because of the changes to > ReadConfig/GetConfigValue haven't been implemented in auth/authldap.c > > > -

Re: [Dbmail-dev] Missing postgres index

2004-05-31 Thread Thomas Mueller
Hi Aaron, > In CVS, lower() has been removed from all mailbox queries to allow for case > sensitive mailbox names (as is common for Unix filesystem based mailers). Nope. The lower() has been removed from every mailbox except for the INBOX. According to the RFC the INBOX has to be case insensitive

Re: [Dbmail-dev] Missing postgres index

2004-05-31 Thread Aaron Stone
In CVS, lower() has been removed from all mailbox queries to allow for case sensitive mailbox names (as is common for Unix filesystem based mailers). Not sure if this behaviour has been changed in 1.2.x, though. Aaron Thomas Mueller <[EMAIL PROTECTED]> said: > Hi, > > I had 800.000 SeqScans o

[Dbmail-dev] Missing postgres index

2004-05-31 Thread Thomas Mueller
Hi, I had 800.000 SeqScans on the mailboxes table in 5 days. The only explanation I have is this missing index: CREATE INDEX mailboxes_name_low_idx ON mailboxes(lower(name)); The INBOX is searched using lower(name). Thomas -- http://www.tmueller.com for pgp key (95702B3B)

[Dbmail-dev] Re: [Dbmail] dbmai - 100% processor

2004-05-31 Thread Thomas Mueller
> > The company I work for has dbmail running on duel processor SuSE amd64 > > machines. For the most part we have had great success with dbmail, but > > every once in a great while it seems as if there is something that > > pushes dbmail to 100% of one of the processors completely blocking it.

[Dbmail-dev] broken auth/authldap.c

2004-05-31 Thread Paul J Stevens
compiling --with-auth-ldap fails because of the changes to ReadConfig/GetConfigValue haven't been implemented in auth/authldap.c -- Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROU

Re: [Dbmail-dev] dynamic library loading

2004-05-31 Thread Dan Weber
For the most part, my code is perfected. I am stumbling across a dbmysql.c bug I can't figure out. The ltdl code has been thoroughly test tho. You can get it using tla. install -d ~/revisions tla my-revision-library ~/revisions tla register-archive http://arch.mirrorlynx.com/[EMAIL PROTECTED

Re: [Dbmail-dev] IRC Meetings

2004-05-31 Thread Dan Weber
John Hansen wrote: On Mon, 2004-05-31 at 09:49, Dan Weber wrote: I think we should start having weekly irc meetings on where dbmail is heading. I think it would help get things accomplished better and get speedy feedback. you might wanna do that in a moderated channel, but it soun

Re: [Dbmail-dev] IRC Meetings

2004-05-31 Thread John Hansen
On Mon, 2004-05-31 at 09:49, Dan Weber wrote: > I think we should start having weekly irc meetings on where dbmail is > heading. I think it would help get things accomplished better and get > speedy feedback. > you might wanna do that in a moderated channel, but it sounds like great idea

[Dbmail-dev] IRC Meetings

2004-05-31 Thread Dan Weber
I think we should start having weekly irc meetings on where dbmail is heading. I think it would help get things accomplished better and get speedy feedback. Dan Weber signature.asc Description: OpenPGP digital signature