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
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
Hi,
I am running Dbmail 3.1.17 with authlog enabled. Database is PgSQL.
Server has lots of processing power (2 sixcore processors, > 128 GB RAM, fast
SAS disks, RAID-6)
The server has 50 simultaneous connections. DB size is 300 GB.
I have noticed a huge performance issue when authlog is enabl
