Thanks a Million for your tips !
Very very good !
Em seg., 13 de mar. de 2023 às 12:45, Rick Otten
escreveu:
> 300M rows isn't "huge", but it is starting to get to be real data.
>
> Some notes/very general rules of thumb since you asked a very general
> question:
> 1. Consider updating the
300M rows isn't "huge", but it is starting to get to be real data.
Some notes/very general rules of thumb since you asked a very general
question:
1. Consider updating the statistics on the table from the default sample
of 100 rows to something larger - especially if you have a wide variety of
da
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 usi
