I don’t, but I didn’t set up the env As far as I can tell, each tablespace is a partition, and I assume they felt this was the best way to perform partition maintenance - again, I don’t know , -----Original Message----- From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> Sent: Sunday, January 3, 2021 11:52 AM To: pgsql-general@xxxxxxxxxxxxxxxxxxxx; Thomas Flatley <FLATLEYT@xxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: Re: Max# of tablespaces On 3 January 2021 13:59:31 CET, Thomas Flatley <FLATLEYT@xxxxxxxxxxx> wrote: >Hello, I've checked the docs but cant seem to find if there is a max # >of tablespaces allowed - I've come across a 9.5 env with 1600 >tablespaces - they want to double that why on earth do you think you will need so many tablespaces? They have an other meaning than in oracle. -- 2ndQuadrant - The PostgreSQL Support Company
