0

I was reading about maximum limits of database objects in Postgres. From PostgreSQL Limits:

enter image description here

My question here is what is the meaning of "can be increased by recompiling PostgreSQL"?

Henry Woody
  • 14,024
  • 7
  • 39
  • 56
VBAGuy
  • 172
  • 1
  • 9
  • It means that it's a constant in the code of postgres, and since that's open source you can change the constant yourself and compile a custom version for usage with increased limits. – Bergi Jul 20 '20 at 16:50

1 Answers1

0

This means that there is no way to update these limit from within Postgres while running—in other words, there is no Postgres command to change any of these values. Instead you'll have to change parameters at a higher level and then recompile Postgres to see the changes take effect. This is likely because these limits (in at least some cases) are set by constant values so the only way to change their value is to change the source then recompile.

In this answer about changing the maximum identifier length, the only way to change the max identifier length limit is to manually change the value of a constant in a config file, then recompile Postgres in order for the changes to take effect.

If you're using a managed cloud solution (like Amazon Aurora), this means you will not be able to change these constraints, as stated in this answer.

Henry Woody
  • 14,024
  • 7
  • 39
  • 56
  • ...we are using postgres aurora...i dont think we can have this kind of .config file changes done? – VBAGuy Jul 20 '20 at 16:57
  • Yeah I don't think it's possible to change these values in Aurora (related: [Can I configure Aurora DB max identifier length? How?](https://stackoverflow.com/questions/60981723/can-i-configure-aurora-db-max-identifier-length-how)) – Henry Woody Jul 20 '20 at 17:00