How to make a multi-criteria filter with full-text search capabilities?

Question

PostgreSQL

Good afternoon! there is a database in postgresql 9.3 with a volume of 25-30 GB. necessary.
The main query pool goes through one table zakaz with a volume of ~4.5M records with the following content:
id (int),
title (varchar),
cod_zakaza (varchar),
description (text),
region (int),
client (varchar),
data_zakaza ( date),
data_ispoln (date) ...
it is these fields that are used to search for the necessary records.
There was a need to add the functionality of full-text search by title + description to the multi-item selection, taking into account all the main forms of the word. for example, searching for a query window in the result included windows, windows, windowed, etc. + even taking into account additional parameters (date, region, order code, etc.).
The use of elastic or sphinx in its pure form, as I understand it, forces you to sacrifice additional parameters.
Can anyone share their experience (thoughts) on the implementation of a similar task?
I will be eternally grateful!

Answer 1

Yes, you don't have to sacrifice anything either there or there.

Answer 2

You won't have to sacrifice any additional parameters, because these engines search by their indexes, and not by the tables whose data they have indexed.