Horton

Huge Tables

André Rodrigues <db.andre@gmail.com>

View thread View on postgr.es
From: André Rodrigues <db.andre@gmail.com>
To: pgsql-performance@postgresql.org
Date: 2023-03-11T11:47:46Z
Lists: pgsql-performance 
Hello Guys

Regarding a particular performance + architecture situation with postgres
12, I have a table with 300 millions rows and then I ask you, which basic
approach like *parameters in postgres.conf*, suitable index type ,
partitions type,  would you suggest me knowing that we have Queries  using
bind with range id  ( primary Key )  +  1 or 2 columns ?


Best regards
Andre