One-Clappers Welcome

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

1073

Abstract

Tablespace in PostgreSQL</figcaption></figure>Types of tablespaces:<ul><li>1.Default tablespace</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>2. Non-Default tablespace The DB objects are stored into specific location/directory Which was defined by user.</li></ul>What are the advantages of using non-default tablespace?1.logically maintaining the objects on specific directory 2.better I/O retention 3.Maintenance activities (like to take backup specific volume backup)To define a tablespace<div id="c707"><pre>CREATE TABLESPACE tbspace1 LOCATION '/u01/postgresql/data';</pre></div>Note:<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>To create DB with tablespace:<div id="31c2"><pre>CREATE DATABASE Sports TABLESPACE tbspace1;</pre></div>To view the tablespace:<ul><li>Here this system catalog to view the existing tablespace .</li></ul><div id="8592"><pre>SELECT * FROM pg_tablespace;</pre></div>List Command To View Tablespace:<ul><li>The below meta-command is also useful for listing the existing tablespaces.</li></ul><div id="5abd"><pre>\db</pre></div></article></body>

A new Medium publication

A group of one-clappers, laughing at YOUR article by Pexels

We’re a new publication and are PUMPED to see you here. In these submission guidelines, you will find:

1. Our mission
2. A selected list of writers we HATE
3. Rules we would like you to follow
4. How to become a writer for One-Clappers Welcome
5. What's next?
6. Our vision for the comment section

Our Mission

Many writers complain about the one-clappers:

“Who the fuck clapped one time?” — Mike Knittel, source.

“Better tell me my writing is shit than clap only once for it” — Philip Ogley, source.

“Fuck you, one-clappers.” — Reuben Salsa, source.

“5 tiny scary stories involving a one-clapper dumbass.” — Kristen Stark, source.

At One Clappers Welcome, we LOVE one-clappers.

Our mission is to bring you articles for which you will never want to clap more than once.

We accept ALL the Medium one-clappers, no matter the reason for your kink.

You might be a one-clapper out of spite, hate, or lack of knowledge; it doesn’t matter to us. We love you all. If you’re one of the ones who feel rejected by all the mean writers complaining about your clapping habits, this is the place for you.

We see you.

We clap you. (only once)

Please follow the rules

Should you refuse to follow our rules, you will be blocked and, if possible, reported.

Rule #1 — you cannot clap more than once for the articles published in One-Clappers Welcome.

Rule #2 — you cannot clap less than once for said articles.

Rule #3 — Don’t proofread your stories, edit them, or use Grammarly. We find it helps people respect rules #1 and #2.

One-Clappers Welcome

A new Medium publication

Our Mission

A selected list of writers we hate

Please follow the rules

How to become a writer for One-Clappers Welcome

What’s next?

Our vision for the comment section

Want to Be Published?

The Pub is the write place to go

How One-Clappers Are Screwing Over Writers

For the love of the claps