Postgres Metrics

2023-04-15 Thread André Rodrigues
template implemented, please share with me or some link to do that , Regards *André Rodrigues *

Re: Huge Tables

2023-03-13 Thread André Rodrigues
se a little > more memory and more parallel processing. Since autovacuums are triggered > by a percentage of change in the table, you may want to lower the > percentage of rows that trigger the vacuums. > > You'll need to get a lot more specific about the issues you are running &g

Huge Tables

2023-03-11 Thread André Rodrigues
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