avatarJeff the Content Profit Coach

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>

TRAFFIC GENERATION | CONTENT | ETMS

The Amazing Power of Evergreen Traffic Machines

And other thoughts and strategies for building an unstoppable flow of high quality free traffic

If you’d like to create a never ending flow of high quality free traffic that you couldn’t stop if you wanted to (and you won’t want to) check out these bulleted strategies:

  • Stop chasing after traffic. Find out where the traffic is already going and get ye in front of it. Then redirect exactly where you want it to go — your profit pages.

I could probably drop the mic right there in the first tip, but here’s a few more for you:

  • Make “traffic building” one of your DRGRs = Daily Revenue Generation Rituals. In this way you are constantly digging the well before you’re thirsty.
  • Create ETMS = Evergreen Traffic Machines. ETMs are a lot like ATMs, except that ETMs spit out traffic instead of money. And traffic leads to money, so…
  • Every time you create a piece of content with links back to your profit sites, you’ve created an ETM.
  • For more thoughts and strategies on creating profitable content visit:

And a few more cool things about ETMs:

  • ETMs, once created, will work for you for years
  • ETMs never take a day off
  • ETMs never call in sick
  • ETMs never ask for a raise
  • ETMs never come to work cranky
  • ETMs work for you, 24/7, all over the world
  • Grab one of these 21 fresh content ideas, create some content, and some links, and I bet you’ll have an ETM working for you before your head hits the pillow tonight
  • And if you want to add the power of social media to the mix, here’s a few more strategies:
Traffic
Traffic Optimization
Content
Content Marketing
Content Creation
Recommended from ReadMedium