Long read from Postgresql?

Question

PostgreSQL

There is a table in Postgresql that does not have indexes, because there is a bulk write and indexes slow down the insert a lot. But without indexes very long reading. Is it a solution to enable elastic search to do searches through it? And will he do replication and store data at home? Or how will it create indexes? Tell me how you can solve the problem with reading data from Postgresql.

Perhaps Sphinx or mongo?

Answer 1

If indexes slow down writing a lot, you need to deal with the performance of the database. Give the numbers - the size of the data, the load, what kind of hardware and how the DBMS is configured.

Answer 2

Full text search engines do not build indexes faster.

Answer 3

As an option - do not write to the database, but write to a file, then the sphinx will be the very thing.