that’s a hassle
-Original Message-
From: Christophe Pettus
Sent: Tuesday, January 5, 2021 5:02 PM
To: Thomas Flatley
Cc: Andreas Kretschmer ;
pgsql-general@lists.postgresql.org
Subject: Re: Max# of tablespaces
> On Jan 5, 2021, at 13:55, Thomas Flatley wrote:
>
> As far
way to perform partition maintenance - again, I don’t know ,
-Original Message-
From: Andreas Kretschmer
Sent: Sunday, January 3, 2021 11:52 AM
To: pgsql-general@lists.postgresql.org; Thomas Flatley ;
pgsql-general@lists.postgresql.org
Subject: Re: Max# of tablespaces
On 3 January 2021 13:59
> On Jan 5, 2021, at 13:55, Thomas Flatley wrote:
>
> 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
> ,
It's a very common Oracle-ism to have a lot of tablespaces, in part because
: pgsql-general@lists.postgresql.org; Thomas Flatley ;
pgsql-general@lists.postgresql.org
Subject: Re: Max# of tablespaces
On 3 January 2021 13:59:31 CET, Thomas Flatley wrote:
>Hello, I've checked the docs but cant seem to find if there is a max #
>of tablespaces allowed - I've come
On 3 January 2021 13:59:31 CET, Thomas Flatley 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 h
On Sun, Jan 3, 2021 at 05:37:52PM +, Thomas Flatley wrote:
> Excellent - thanks for the fast response - it was an oracle dba that set it
> up initially so that may explain it -
Agreed. It was probably done that way for an invalid reason and should
be cleaned up.
--
Bruce Momjian
Excellent - thanks for the fast response - it was an oracle dba that set it up
initially so that may explain it -
Thanks very much
-Original Message-
From: Tom Lane
Sent: Sunday, January 3, 2021 12:27 PM
To: Thomas Flatley
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Max# of
Thomas Flatley writes:
> 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 - Oracle's max is 64k, I'm not particularly worried about
> hitting a wall, if there is one ,
