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