Re: [GENERAL] [ADMIN] calculating table and index size

Hello, Thanks for helpful answers and sharing all of your knowledge about this issue. Your knowledge gave me ideas and made it more clear. Thank all of you again. Best regards, Gunce On Fri, Apr 7, 2017 at 6:30 PM, Guillaume Lelarge wrote: > Le 7 avr. 2017 4:58 PM,

Re: [GENERAL] [ADMIN] calculating table and index size

Le 7 avr. 2017 4:58 PM, "Alban Hertroys" a écrit : On 7 April 2017 at 09:11, Günce Kaya wrote: > Hi again, > > Sorry for delay. > > Guillaume, I read your answer for first question but It's not clear to me. > The table has a column and index also use

Re: [GENERAL] [ADMIN] calculating table and index size

On 7 April 2017 at 09:11, Günce Kaya wrote: > Hi again, > > Sorry for delay. > > Guillaume, I read your answer for first question but It's not clear to me. > The table has a column and index also use that column. so in that example, I > think table size and index size

Re: [GENERAL] [ADMIN] calculating table and index size

Hi again, Sorry for delay. Guillaume, I read your answer for first question but It's not clear to me. The table has a column and index also use that column. so in that example, I think table size and index size should be equal. Why these are not equal? Your answer for second question is pretty

Re: [GENERAL] [ADMIN] calculating table and index size

Hello, try pgstattuple() and pgstatindex() , I think you will figure it out. Steven 2017-04-05 16:56 GMT+08:00 Guillaume Lelarge : > Hi, > > 2017-04-05 9:44 GMT+02:00 Günce Kaya : > >> Hi all, >> >> I have some questions about calculating

Re: [GENERAL] [ADMIN] calculating table and index size

Hi, 2017-04-05 9:44 GMT+02:00 Günce Kaya : > Hi all, > > I have some questions about calculating table and index size. > > I have a dummy table which has an integer column and its index. The table > has 140 rows and all of rows are same thats value is 2000. Table >