Thread: extensive data use setting in production
hi
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
do you have strategy or setting to suggestion ?
Many thanks
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