Count estimate seems to produce inaccurate results for small tables

[oltarasenko]

Some example is here:

http://crawlyui.com/logs/267/list

The count estimate for this query shows 320. The actual amount of rows in the table is 4. As a result, we have long pagination without items.

[oltarasenko]

I think it makes sense to introduce triggers instead of the count estimate. Some related articles to read: http://www.varlena.com/GeneralBits/49.php http://www.varlena.com/GeneralBits/120.php