Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns8l0-0000un-0v for pgsql-admin@arkaria.postgresql.org; Fri, 20 May 2022 19:57:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ns8ky-0000tu-Qs for pgsql-admin@arkaria.postgresql.org; Fri, 20 May 2022 19:57:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ns8ky-0000ti-Ef for pgsql-admin@lists.postgresql.org; Fri, 20 May 2022 19:57:52 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ns8kw-0005zA-B6 for pgsql-admin@lists.postgresql.org; Fri, 20 May 2022 19:57:51 +0000 Received: by mail-oi1-x231.google.com with SMTP id i66so11119337oia.11 for ; Fri, 20 May 2022 12:57:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to:content-transfer-encoding; bh=IpP2OyOALbbXskDVAJF9cJ3H7ckfOWIngDH/R5VoAWw=; b=jXNMr4u+vGy+9NmoiMBzRN6QQYh/BE4Tx43KGjJAJKNEO7nBhtXCDpcdSV4bKiYiuS NKNVmmhKfOYps8epPB/gDJorXI3NxWeKgv73+RzaUTKnse4cD90fiypIUNKqDNMdcuJB ZDrlA+lG/Lntu7KxEWbUbFaej47y+p99y+mM6TvtA6AwFJvAJOJf36MubI4XtjjQrR3X 0H5BOjzXrcJgoL+VP0ppp+ttjRLi4ZlgAWTASoulAWqtyTq3YwE6qeJGcQJZDTxU0bfd hjzFW02i38ck8VdqikadnQiWqb9Hx5d28cUEy3EdBfELZvxa25jBlChQda5hJPJryf9A LXQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to :content-transfer-encoding; bh=IpP2OyOALbbXskDVAJF9cJ3H7ckfOWIngDH/R5VoAWw=; b=jyco2J227YTTzHe6Vq3P7XHXzCTMh0hE/iv4y3qmDa8bTpi/Kv4b+wMLYD/Yg3lQWu UZuyGo9rvc/aPzhS/jDRTIFRgYJ9FZ1GqHOSO6Xi8BYb/s6XcceU163HF9V9Ze0h11+w nHvkVe0Hx9JB4nx7vjLPr29e3IllcOqOVBTjALtj/vdlu6tOddaFcnzNrg2SE1gpxnpJ k8/oDTQdvvvdjsA9bFJP91V9FslCgxFx+wXCjk7EeYnp4r551fEyPS7otSQsABuOrShx jaO9JGmaUtomATvvpw9yBg7biAWmcSTfNJm0OLA7yfsQZPSHU/DYu/2jMs83BAgq37kd 3HRw== X-Gm-Message-State: AOAM533Eno9E8tqfiO1VeRu1fKfdKjOM9VQ+MUQZBnjzmpXZsyTvpaPo gwoW7upSHk73TpObq7MaZjPsPBDsexk= X-Google-Smtp-Source: ABdhPJzNId7r+URgwxDDDN7l4uVbUt+Et5yy+E/YMuqkdC6qtjLIRrO1wZyRL17XF+L4vJPsYqQ9Tg== X-Received: by 2002:a05:6808:ec7:b0:322:2bcc:42c2 with SMTP id q7-20020a0568080ec700b003222bcc42c2mr6714288oiv.168.1653076669406; Fri, 20 May 2022 12:57:49 -0700 (PDT) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id i127-20020aca3b85000000b00325cda1ffa5sm1417978oia.36.2022.05.20.12.57.48 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 May 2022 12:57:48 -0700 (PDT) Message-ID: <7ac101e4-52fe-6b80-cb76-8641b8a3c386@gmail.com> Date: Fri, 20 May 2022 14:57:47 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.8.1 Subject: Re: Many databases ou many schemas Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <1316242401.254966.1653056142041@email.ionos.com> From: Ron In-Reply-To: <1316242401.254966.1653056142041@email.ionos.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/20/22 09:15, MichaelDBA Vitale wrote: > In PG, tablespaces only have importance when mapping them to different > mount points that might have different IO response times. Or if for some reason "you" don't want to use lvm. Likewise, auditors or upper management might say that each "database" must be in a separate folder. -- Angular momentum makes the world go 'round.