RE: Max# of tablespaces

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@a-kretschmer.de> 
Sent: Sunday, January 3, 2021 11:52 AM
To: pgsql-general@lists.postgresql.org; Thomas Flatley <FLATLEYT@outlook.com>; pgsql-general@lists.postgresql.org
Subject: Re: Max# of tablespaces

On 3 January 2021 13:59:31 CET, Thomas Flatley <FLATLEYT@outlook.com> 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