Le 22/02/2019 à 17:06, Robert Haas a écrit :
> On Wed, Feb 20, 2019 at 5:26 PM Gilles Darold
> wrote:
>> The attached simple patch adds this feature. Is there any cons adding
>> this information?
> Well, it'll take time to compute, maybe a lot of time if the database
> is big and the server is
Le 22/02/2019 à 19:21, Tom Lane a écrit :
> Robert Haas writes:
>> On Wed, Feb 20, 2019 at 5:26 PM Gilles Darold
>> wrote:
>>> The attached simple patch adds this feature. Is there any cons adding
>>> this information?
>> Well, it'll take time to compute, maybe a lot of time if the database
>>
On Fri, Feb 22, 2019 at 7:22 PM Tom Lane wrote:
>
> Is there any permissions issue involved here? I'd be a bit worried
> about whether \dn+ could fail, or deliver misleading answers, when
> run by a user without permissions on (some) tables. Also, even if
> we allow people to get size info on
Robert Haas writes:
> On Wed, Feb 20, 2019 at 5:26 PM Gilles Darold
> wrote:
>> The attached simple patch adds this feature. Is there any cons adding
>> this information?
> Well, it'll take time to compute, maybe a lot of time if the database
> is big and the server is busy. Not sure how
On Wed, Feb 20, 2019 at 5:26 PM Gilles Darold wrote:
> The attached simple patch adds this feature. Is there any cons adding
> this information?
Well, it'll take time to compute, maybe a lot of time if the database
is big and the server is busy. Not sure how serious that problem can
get.
--
Le 21/02/2019 à 21:57, Jerry Sievers a écrit :
> Gilles Darold writes:
>
>> Le 21/02/2019 à 18:28, Julien Rouhaud a écrit :
>>
>>> On Thu, Feb 21, 2019 at 5:42 PM Gilles Darold
>>> wrote:
Le 21/02/2019 à 12:01, Julien Rouhaud a écrit :
> On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold
Gilles Darold writes:
> Le 21/02/2019 à 18:28, Julien Rouhaud a écrit :
>
>> On Thu, Feb 21, 2019 at 5:42 PM Gilles Darold
>> wrote:
>>> Le 21/02/2019 à 12:01, Julien Rouhaud a écrit :
On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold
wrote:
>> When we want to get total size of
Le 21/02/2019 à 18:28, Julien Rouhaud a écrit :
> On Thu, Feb 21, 2019 at 5:42 PM Gilles Darold
> wrote:
>> Le 21/02/2019 à 12:01, Julien Rouhaud a écrit :
>>> On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold
>>> wrote:
> When we want to get total size of all relation in a schema we have to
On Thu, Feb 21, 2019 at 5:42 PM Gilles Darold wrote:
>
> Le 21/02/2019 à 12:01, Julien Rouhaud a écrit :
> > On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold
> > wrote:
> >>> When we want to get total size of all relation in a schema we have to
> >>> execute one of our favorite DBA query. It is
Le 21/02/2019 à 12:01, Julien Rouhaud a écrit :
> On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold
> wrote:
>>> When we want to get total size of all relation in a schema we have to
>>> execute one of our favorite DBA query. It is quite simple but what
>>> about displaying schema size when using
On Thu, Feb 21, 2019 at 11:49 AM Gilles Darold wrote:
>
> > When we want to get total size of all relation in a schema we have to
> > execute one of our favorite DBA query. It is quite simple but what
> > about displaying schema size when using \dn+ in psql ?
> > [...]
> > The attached simple
Le 20/02/2019 à 23:26, Gilles Darold a écrit :
> Hi all,
>
>
> When we want to get total size of all relation in a schema we have to
> execute one of our favorite DBA query. It is quite simple but what
> about displaying schema size when using \dn+ in psql ?
>
>
> gilles=# \dn+
>
Hi all,
When we want to get total size of all relation in a schema we have to
execute one of our favorite DBA query. It is quite simple but what
about displaying schema size when using \dn+ in psql ?
gilles=# \dn+
List of schemas
Name | Owner | Access
13 matches
Mail list logo
