Postgresql – AWS Postgres – max pid

postgresql

Not sure what sort of platform AWS runs 9.x Postgres on. What's the maximum value for the process pid?

Im looking into an issue around the use of pg_backend_pid in a trigger.

Best Answer

AWS doesn't run PostgreSQL.

What's the maximum value for the process pid? Im looking into an issue around the use of pg_backend_pid in a trigger.

I assume the maximum value for process pid is the maximum pid value for Linux.

But, for PostgreSQL it's stored in an interger.

select pg_typeof(pg_backend_pid());
 pg_typeof 
-----------
 integer
(1 row)

Which means the max value is pow(2,31)-1