Is it possible to use COUNT(*) along with Limit?

Question

PostgreSQL

I need to check if there are more files in the database than 1000.
COUNT(*) is not suitable for me. takes too long, is there any quick way to just know if there are enough files to process or not? Thus without scanning all table.

Answer 1

try like this

select count(*) from 
(select * from some_table limit 1000) a

Answer 2

Get an index in the table and count, for example, count(id).
Another option is to have triggers for insertion and deletion so that they change the corresponding counter. But here it is necessary to carefully organize transactions.