With what parameters is it better to create a table for maximum sampling speed?

Question

PostgreSQL

With what parameters is it best to create a PostgreSQL table to increase the speed of indexing / fetching *at the expense of data integrity*?
How much can be gained by making it non-journaled? And what else can you think of to maximize the sampling rate?

There is a table with 50+ million rows, which continues to grow and in the future it will be 100 million.
Based on this data, you need to regularly do COUNT (*) to understand how much data has been processed / not processed.

Data integrity is not critical. If a couple of records are lost, it's okay. No transactions are required for this table.

There are many indexes on the table to increase the speed of selections. At the same time, new data is written and their tables are selected for data that has not yet been processed.

Answer 1

Many times, different people tried to make a queue from the database, it did not work.