avatarPeter W

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

1073

Abstract

<b>Tablespace in PostgreSQL</b></figcaption></figure><p id="e6e7"><b>Types of tablespaces:</b></p><ul><li><b>1.Default tablespace</b></li><li>when we are creating DB without specifying tablespace location by default objects are stored into pg_default 1.pg_default → all the user related objects are stored here 2.pg_global → all the system related objetcs are stored here</li><li><b>2. Non-Default tablespace</b> The DB objects are stored into specific location/directory Which was defined by user.</li></ul><p id="7986"><b>What are the advantages of using non-default tablespace?</b></p><p id="d9f2">1.logically maintaining the objects on specific directory 2.better I/O retention 3.Maintenance activities (like to take backup specific volume backup)</p><p id="d781"><b>To define a tablespace</b></p><div id="c707"><pre><span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">TABLESPACE</span> tbspace1 <span class="hljs-keyword">LOCATION</span> <span class="hljs-string">'/u01/postgresql/data'</span>;</pre></div><p id="7f9c"><b>Note:</b></p><ul><li>The

Options

location must be an existing, empty directory that is owned by the PostgreSQL operating system user. All objects subsequently created within the tablespace will be stored in files underneath this directory.</li><li>Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary database users to use it</li></ul><p id="7a6e"><b>To create DB with tablespace:</b></p><div id="31c2"><pre><span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">DATABASE</span> Sports <span class="hljs-keyword">TABLESPACE</span> tbspace1;</pre></div><p id="bc64"><b>To view the tablespace:</b></p><ul><li>Here this system catalog to view the existing tablespace .</li></ul><div id="8592"><pre><span class="hljs-keyword">SELECT</span> * <span class="hljs-keyword">FROM</span> pg_tablespace;</pre></div><p id="7c7f"><b>List Command To View Tablespace:</b></p><ul><li>The below meta-command is also useful for listing the existing tablespaces.</li></ul><div id="5abd"><pre><span class="hljs-string">\db</span></pre></div></article></body>

How I gained 10 pounds of Muscle Mass in 3 Months

These things helped me to finally gain some muscle

Photo by Norbert Buduczki on Unsplash

I was a skinny kid.

My metabolism is very good by nature. On the one hand, this is a blessing, as it is easy for me to maintain a low body fat percentage. On the other hand, a disadvantage, because it is difficult for me to build muscle.

When I started to train in the gym, the first successes appeared, but the progress was very slow. It was only when I started taking the following two supplements that I was able to significantly increase my strength and finally achieve the desired visible results.

Whey Protein

Eating enough protein is the most important thing when building muscle. In simple terms, you can imagine the process of muscle building like this:

First, you need to train. Strength training in the gym causes small injuries in your muscles. You may feel them in the form of muscle soreness in the following days.

After training, an adaptation reaction of the body is triggered. First, the muscle must repair itself, for which proteins are the basic building blocks. If you supply enough protein in the recovery phase, the muscle recovers better and becomes stronger and bigger. If you repeat this process often enough, you will gain muscle mass.

Building muscle is a simple process: Break down your muscles in the gym, refuel with a lot of protein, take some time to recover, repeat.

To make sure you get enough protein, it is recommended to take a protein supplement. Personally, I was able to achieve excellent results with this whey protein.

Creatine

Creatine consists of the three amino acids L-arginine, L-methionine, and L-glycine. It is found in meat, especially red meat. Hence the name, because in Greek “kreas” means meat. In addition, creatine is formed in the human body itself in the so-called self-synthesis. In this way, one to two grams are produced daily. This process takes place in the liver, kidneys, and pancreas.

Creatine has numerous positive effects on strength and muscle building, which is why the consumption of creatine supplements is very popular. It improves strength performance and delays muscle fatigue. It also stores water within the muscles, leading to weight gain and a more voluminous appearance.

For the optimal effect, you should take 3–5g a day, which is almost impossible through food. Therefore supplements make sense.

My personal experience

I took 5 grams of creatine every day for a few weeks and trained hard in the gym 4 times a week. After a few days, I felt stronger than usual. It felt like cheating. I set new personal bests in almost all exercises. In the next training sessions, it went on and on.

This supplement is what allowed me to achieve these great results.

Wait a second. You should get my articles in your inbox. Subscribe here. Maybe you also want to start writing on Medium yourself and make money. I made $2300 in my second month! You only need a membership for $5 a month. If you sign up with my link, you support me with a part of your fee without any additional costs for you.

I think you will also like these articles:

Disclaimer: I used an Amazon affiliate link. There will be no additional cost for you.

Fitness
Health
Life
Life Lessons
Motivation
Recommended from ReadMedium