What should I do when my data volume is very large, more than 100 million?

Question

smockgithub opened this issue 4 years ago · 3 comments

When there is a lot of data, the relational table will generate a lot of data. How to deal with it to ensure performance?

Answer 1 · 2021-09-17T13:41:46.000Z

throw more money to your postgres instance?

Answer 2 · 2021-09-17T16:22:49.000Z

@smockgithub this question is very vague. You are not defining what is performance nor which database you using.

If you experience slowness, you maybe need a bigger instance or some caching mechanism.

Answer 3 · 2023-04-10T23:38:53.000Z

Can this be closed?

Not sure if there are any other answers besides "ensure your indexes are meeting your needs" and "ensure the postgres instance is big enough"