About the talk
My name is RJ Kumar. I'm working a software specialist integration in error State, electricity board. And I think this is the sixth video conference for me. Space consumed by a postgresql cable. Supposed to recycle table is actually a file within the file system. if you open the operating system file system, you'll be able to see a global folder inside another folder, 16387, something like that, that is actually the database name, the folder in global photo. And within that folder corresponding to a table, there
will be always a file. So 51330 represents a table. The maximum size allocated to that file is 1. GB space is allocated to that table. It means that it is only the maximum says then, what is this space? Allocated humans created. So instead of allocating a 1GB file, what posters disease allocate space in increments of 8, KB to be is called a page. So one piece sizes, 8 KB and which internet page will be inserted. This is but this is not my subject. I see our data to a table. New pages are created in a little bit KB. Then you when you insert more data,
then the next day we will be here. One, two, three, four, four pages are created So as you insert data into a table. File size, grows in the increment of hkb size. No, I am. Updating three rules. So, normally, what people think that if you update something that just changing up data, which is which already exists, there you are thinking something which already exists in the file. But what happens if y'all dated, this three questions? When I update, those three patients will be more diligent than new. 3, what is
you don't confuse with page with Rob and I am just showing that the updates. Also delivered gutters for neurotic. That means if you update data file, size increases, again, you delete Again when you delete the pages are marketed, no data is removed from that file again. When you delete the page size, that's not the case. So, how did you get the new runs? Welcome home runs. The deleted pages will be removed from that file, but the file size does not. In. If you add more data into the table, that empty spaces will be filled with the data
base of the spine. We're leaving you run back home. At the time that instantly, you can reduce file size of a table, small point, but I think it will be useful for you. If you want to reduce the size of vacuum full command, which will reduce the size of a table. Thank you.
Buy this talk
Buy this video
With ConferenceCast.tv, you get access to our library of the world's best conference talks.