Tobias Kreidl wrote: > Alejandro, > > The whole idea of the throttle table is to limit the amount of email of > a sender for a certain period of time. As the time expires, so do the > records. You need only establish limits that are applied to all users > (thoug you can set exceptions in the whitelist), but the throttle and > throttle_from_instance table will grow and shrik according to the time > limits set and how often you run the cleanup process. In other words, > this is normal behavior.
In my use case, I had two specific sending users that I wanted to throttle, everyone else (default=0) was not. In this use case, these specific users entries would be deleted after some time and I would have to go back and enter them. > As to the row and size limits, those would be huge numbers; the tables > can in principle grow to millions of rows and many gigabytes of data, > but this is why you want to expire old records regularly (such as once > an hou) to keep old records from making the table huge and slower. In > our case, we only keep about two hours' worth of data and use a one-hour > window. The biggest I've seen the throttle table grow to is perhaps > 6,000 rows or so. Typically, it hits around 3,000 just before the > cleanup process runs. > Our needs and hence our tables are simple and only take up a couple of > megabytes; we process several hundred thousand messages a day, so > efficiency is important. > > --Tobias > > John Beaver wrote: >> Alejandro Cabrera Obed wrote: >> >>> Dear all, I have postfix-policyd in order to put a message size quota to >>> my LAN users. >>> >>> I fill the THROTTLE table from the POSTFIXPOLICYD database with the >>> users' mail and quota, that's OK and it works. But after a time, the of a >>> sender >>> throttle table becomes empty and I hav eto fill it again. >>> >>> Does throttle table have a size limit or row limit ???? >>> >> It doesn't have a limit but if the user does not send any mail during a >> time period, their record may be "cleaned" (removed). >> Not sure the details of how it worked, because it happened only once. >> My user was heavy on sending emails :) >> >> >> Check out the clean process and you'll find out why it gets removed. >> john >> >> ------------------------------------------------------------------------- >> SF.Net email is sponsored by: The Future of Linux Business White Paper >> from Novell. From the desktop to the data center, Linux is going >> mainstream. Let it simplify your IT future. >> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 >> _______________________________________________ >> policyd-users mailing list >> policyd-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/policyd-users >> > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > policyd-users mailing list > policyd-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/policyd-users ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users
