how to improve the search speed for Ten-Million datas

[AliredDevils]

Now, i use the PostgreSQL as backend to store my datas which is ten million level.
And some tests for me,finding that:

1.Get note by name: cost about 5-6 seconds, it will be slower for me.

2.List notes in one project: cost about 70 million-seconds.

So i want to know how to improve the search speed for the note or occurrence?

Thanks

[argowang]

You should consider change the data type from json to jsonb and create indexes on common fields you query.