Re: [SUPPORT] How to calculate size of tables which are saved on disk? - Mailing list pgsql-bugs

From Pavlo Golub
Subject Re: [SUPPORT] How to calculate size of tables which are saved on disk?
Date
Msg-id 867811826.20181205163353@cybertec.at
Whole thread Raw
In response to [SUPPORT] How to calculate size of tables which are saved on disk?  (Nguyen Thi Nhu Thuy <ntnthuy88@gmail.com>)
List pgsql-bugs
Greetings, Nguyen.

Have you checked https://wiki.postgresql.org/wiki/Disk_Usage ?

You wrote 29.11.2018, 10:40:

> Hello Everyone,


> My name is Thuy.


> This matter is not bug, but I have a question as below. May you help me?
> How to calculate size of tables which are saved on disk?
> Based on my internet searching, how to calculate the length of the table based on the formula:


> 8KB × ceil(number of records / floor(floor(8KB × fillfactor - 24) / (28 + data length of 1 record)))


> Example:
> Column    |     Type      |
> ----------+---------------+
>  aid      | integer       |
>  bid      | integer       |
>  abalance | integer       |
>  filler   | character(84) |
>  


> data length of 1 record = aid(4 bytes) + bid(4 bytes) + abalance(4
> bytes) + filler(84 bytes + 1 byte) = 97 byte
> The data length of a record must be rounded to 8 bytes.
=>> Data length of 1 record is 104 bytes.


> Therefore, I think that 1 character is contained in 1 byte of memory.
> However,  column "filler" can be input with 84 characters "a"
> (single byte) or 84 characters "あ" (double-byte)


> I don’t know why double-byte character can be contained in single byte character?
> Can you explain to me this question?


> Thank you in advance.




--
Kind regards,
 Pavlo                          mailto:pavlo.golub@cybertec.at



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15536: ERROR: column "value " does not exist
Next
From: Pavlo Golub
Date:
Subject: Re: BUG #15505: pgadmin 4