Events Add an event Speakers Talks Collections
 
Duration 05:09
16+
Play
Video

PGConf India 2020 - Lightning Talk - Space consumed by a PostgreSQL Table - Ajay Kumar - KSEB

Ajay Kumar
Assistant Engineer at Kerala State Electricity Board
  • Video
  • Table of contents
  • Video
PGConf India, 2020
February 26, 2020, Bengaluru, India
PGConf India, 2020
Request Q&A
PGConf India, 2020
From the conference
PGConf India, 2020
Request Q&A
Video
PGConf India 2020 - Lightning Talk - Space consumed by a PostgreSQL Table - Ajay Kumar - KSEB
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Add to favorites
62
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
  • Description
  • Transcript
  • Discussion

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.

Cackle comments for the website

Buy this talk

Access to the talk “PGConf India 2020 - Lightning Talk - Space consumed by a PostgreSQL Table - Ajay Kumar - KSEB”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Standart

Get access to all videos “PGConf India, 2020”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ticket

Interested in topic “IT & Technology”?

You might be interested in videos from this event

September 28, 2018
Moscow
16
179
app store, apps, development, google play, mobile, soft

Similar talks

Robert Haas
VP, Chief Database Scientist at EnterpriseDB
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ashutosh Bapat
Senior PostgreSQL Architect at EDB
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Jim Mlodgenski
Principal Engineer at Amazon Web Services
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Buy this video

Video

Access to the talk “PGConf India 2020 - Lightning Talk - Space consumed by a PostgreSQL Table - Ajay Kumar - KSEB”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
816 conferences
32658 speakers
12329 hours of content