Re: ToDo: show size of partitioned table

2018-06-20 Thread Pavel Stehule
2018-06-20 7:44 GMT+02:00 Amit Langote : > On 2018/06/02 0:15, Ashutosh Bapat wrote: > > I think we should at least display "Type" as "partitioned table" for a > > partitioned table, so that it's easy to understand why the size is 0; > > partitioned tables do not hold any data by themselves. > >

Re: ToDo: show size of partitioned table

2018-06-19 Thread Amit Langote
On 2018/06/02 0:15, Ashutosh Bapat wrote: > I think we should at least display "Type" as "partitioned table" for a > partitioned table, so that it's easy to understand why the size is 0; > partitioned tables do not hold any data by themselves. There was a long discussion last year (during PG 10

Re: ToDo: show size of partitioned table

2018-06-19 Thread Jeevan Ladhe
On Fri, Jun 1, 2018 at 8:51 PM, Pavel Stehule wrote: > > > 2018-06-01 17:15 GMT+02:00 Ashutosh Bapat >: > >> On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule >> wrote: >> > Hi >> > >> > postgres=# SELECT count(*) from data; >> > ┌─┐ >> > │ count │ >> > ╞═╡ >> > │ 100 │ >> >

Re: ToDo: show size of partitioned table

2018-06-01 Thread Pavel Stehule
2018-06-01 17:15 GMT+02:00 Ashutosh Bapat : > On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule > wrote: > > Hi > > > > postgres=# SELECT count(*) from data; > > ┌─┐ > > │ count │ > > ╞═╡ > > │ 100 │ > > └─┘ > > (1 row) > > > > \dt+ can display actual size of

Re: ToDo: show size of partitioned table

2018-06-01 Thread Ashutosh Bapat
On Fri, Jun 1, 2018 at 12:56 AM, Pavel Stehule wrote: > Hi > > postgres=# SELECT count(*) from data; > ┌─┐ > │ count │ > ╞═╡ > │ 100 │ > └─┘ > (1 row) > > \dt+ can display actual size of partitioned table data - now zero is > displayed > > postgres=# \dt+ data >

<    1   2