Huge Tables - Mailing list pgsql-performance

From André Rodrigues
Subject Huge Tables
Date
Msg-id CAPaZWvYNycDcpa4y=9XgEv2Rt+wwJP86jjWv2jMvF0uYpCBP=Q@mail.gmail.com
Whole thread Raw
Responses Re: Huge Tables  (Rick Otten <rottenwindfish@gmail.com>)
List 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 


pgsql-performance by date:

Previous
From: Samed YILDIRIM
Date:
Subject: Re: INSERT statement going in IPC Wait_event
Next
From: Jeff Janes
Date:
Subject: Re: Planner choosing nested loop in place of Hashjoin