I am building a multi-tenant deployment with multiple database - 1 tenant per database.
I would like to be able to dedicate specific temp tablespace to a specific database or user/schemas. I understand how to define temp_tablespace in postgresql.conf. I can't find anything in the documentation on how to dedicate a specific temp_tablespaces to a specific database, user or schema. I also thought maybe I could create a trigger on logon to set a specific temp tablespace per user, but I can't do that either. Is it possible in Postgresql to dedicate a specific temp tablespace to a specific database or user/schema? Thank you for the help. JD
