Re: Max# of tablespaces

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Max# of tablespaces
Date: 2021-01-05 22:02:12
Message-ID: c53ebfd6-886d-b4e1-87ce-2e07d4323796@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It's certainly the "I only know bash" method of determining which partition
growing the fastest.

On 1/5/21 3:55 PM, Thomas Flatley wrote:
> 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.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2021-01-05 22:05:51 Re: FTS and tri-grams
Previous Message Christophe Pettus 2021-01-05 22:01:59 Re: Max# of tablespaces