I'm about to create a Postgres table with 1.5 billion rows. The table will just have a single TEXT column.
The table is effectively a blacklist. When a user of my software saves certain data, this table is looked-up to make sure the value they're saving doesn't exist in it.
What can I do to optimise Postgres or that table to make that "read" as fast as possible? The table will only ever be written to approximately once a year.