python - indexing db content to elastic search -

hello working on django project backend database postgresql server. , have chosen elastic search search engine project.

i have used elastic search-dsl-py create mapping between django models , elastic search doc type. , use django signals capture update , delete events.

by way, haven't mapped fields django model elastic search.

when user search he/she get's list of item homepage elastic search server. when user clicks item list. should query detail data of item, in elastic_search server or in postgres server

if put details of every object in elastic server, going pain me as, there nested relation in django models.

if don't put details in elastic search server, need query database, detail of item going slow compared elastic search query.

which approach should go?

index properties along nested relation in elastic search server , querying operation elastic search.

or

index necessary field in elastic search server, , detail view, q query database required field id.

does have kind of experience before?

this decision depends on trying address elastic search. worked on project used elastic search. reason speed searching , provide better search result. detail of selected product queried database (mssql). decision map or few fields depends on wanted out of elastic search.if better search result (result + speed) suggest map fields user searching.