Nodestore_node table takes more than 100ms to insert a record

The nodestore_node table is slow to insert data when it has more than 20 million(200 * 3600 * 24 * 14). How can I solve this problem.

This sounds more like a Postgres question?

We’re looking into ways to store less data in nodestore itself, however that takes time.

Using postgres as nodestore backend is also a bit suboptimal, we use a different KV-store in production. However this is the only backend we have right now that is easily portable/installable across platforms.

1 Like