Re: [Dbmail] dbmail_authlog performance

2015-02-24 Thread Alan Hicks
Hi, The following update should add the missing primary key so you get sub second response times. ALTER TABLE dbmail_authlog ADD PRIMARY KEY (id); Kind regards, Alan On 23/02/2015 20:05, Rogerio Pereira wrote: Hi, I am running Dbmail 3.1.17 with authlog enabled. Database is PgSQL. Server

Re: [Dbmail] new feature

2015-02-24 Thread Alan Hicks
To avoid ambiguity would it be worth naming it something like login_disabled_no_tls? On 18/02/2015 21:00, Paul J Stevens wrote: Hi all, Just added a nice new feature to pop3 dbmail.conf option: login_disabled = yes If you have tls configured, and this option as well, users will not be al

Re: [Dbmail] dbmail_authlog performance

2015-02-24 Thread Rogerio Pereira
Defintely it makes sense and it works. I noticed the absence of a primary key before. Millions of records in a nonindexed table? Hummm...It doesn’t feel right. Thanks for the quick response. I suggest adding this PK on new dbmail releases. It will boost performance in heavy loaded servers. Since