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.
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
