On Mon, 2025-06-16 at 12:31 +0700, Noppavong Chalermlapvaraboon wrote:
> is postgres-sql can support
>
> data around 200-300 million rows around 4-5 table
> with query multiple joins and high read write
>
> concurrent user around 4000 connections
Sure.
> do you have strategy or setting to suggestion ?
- test your application well with realistic amounts of test data
- use a connection pool
- keep your database transactions very short
- tune your statements so that they are fast
- consider when you can discard old data and design partitioning accordingly
- don't use a cloud service
- implement good monitoring, including monitoring for your backup
Yours,
Laurenz Albe
