Is it possible to configure Postgres to split out a full text search over multiple CPU processes in an attempt to complete quicker?
I'm running a full text search on 2 million records on a GIN indexed tsvector column, where the source text is about 10,000 characters long.
I have way more CPU than is being used during the search, so I feel like splitting the search over 4 processes in batches of 500k would allow it to run the search concurrently and therefore complete faster.
I'd be interested to know if anyone has tried this or implemented their own equivalent programatically in SQL.
select version();
will tell you)