search

toncenter / ton-indexer

TON Indexer system to store and serve blockchain data using SQL-database
https://toncenter.com/api/v3/
GNU General Public License v3.0
68 stars 33 forks source link

The PostgreSQL database slows down as it grows larger #89

Open hsmang opened 1 month ago

hsmang commented 1 month ago

Hello

I'm running a full-node. I'm using the ton-indexer worker, but as the PostgreSQL database grows, select queries take a very long time.

Is there a solution for this?

leoenes commented 1 month ago

exactly the same is happening to me. Even splitting worker (write RDS instance) to api (reader instance)