There isn't a standard option to do this, but you can achieve this several ways.
- create a separate db aand move your log tables there. set a max file size.
- create a trigger which checks row count or table size aand limits inserts when value exceeded and/or deletes old data.
- create a foreign key constraint on an id column pointing to a table with a set number of rows. whenWhen your log table reaches the maximum it will stop.
- add a check constraint.