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

On 3 January 2021 13:59:31 CET, Thomas Flatley <FLATLEYT(at)outlook(dot)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