I need to filter out logging for some tables. We have an application which often query for a settings table and for pg_proc. This pollutes postgresql.log with numerous useless queries and we are looking for a way to skip logging entirely for those. Any suggestion?
There's no way to do that natively with PostgreSQL. But perhaps some extensions can help you get that, though I know none that would.