Ygthkb

How do dictionaries source attestation?

Website seeing facebook data from another site?

What is an efficient way to digitize a family photo collection?

What would be some possible ways of escaping higher gravity planets?

How bad is a Computer Science course that doesn't teach Design Patterns?

Where does documentation like business and software requirement spec docs fit in an agile project?

Is the symmetric product of an abelian variety a CY variety?

Are all power cords made equal?

"Starve to death" Vs. "Starve to the point of death"

Boss asked me to sign a resignation paper without a date on it along with my new contract

What is a good way to explain how a character can produce flames from their body?

why typing a variable (or expression) prints the value to stdout?

Does it take energy to move something in a circle?

RS485 using USART or UART port on STM32

Besides PR credit, does diversity provide anything that meritocracy does not?

Identical projects by students at two different colleges: still plagiarism?

Should a new user just default to LinearModelFit (vs Fit)

Why is Shelob considered evil?

How to deal with an underperforming subordinate?

How to politely refuse in-office gym instructor for steroids and protein

How can find the 2D Voronoi cell area distribution?

Kernel and image of matrix: What are they? Why do they exist?

Is .NET Framework 3.5 still needed with a SQL Server 2017 installation to utilize Database Mail?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Creating tablespaces in Postgresql ; Best practices

0

PostgreSQL version : 11.2

OS : RHEL or Oracle Linux 7.6 (Yet to be decided)

I am at the design stage of setting up a production database. In production, this DB size will be around 300GB to 400GB in size.

This is what I have in mind. Please let me know if this is a good idea for a Postgres production deployment.

I will get the below filesystems mounted with the following sizes.

/db ----> 50 GB

/db_data ---> 500 GB

I will initialize the database cluster in the custom location /db/postgres/pg11/data .

And right from the start I will start creating tablespaces like below

CREATE TABLESPACE orders_tbs LOCATION '/pgdata/<db_name>/orders_tbs';

and place business objects in these tablespaces like below

CREATE TABLE orders (id int, order_item text) tablespace orders_tbs;

postgresql

share

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

PostgreSQL version : 11.2

OS : RHEL or Oracle Linux 7.6 (Yet to be decided)

I am at the design stage of setting up a production database. In production, this DB size will be around 300GB to 400GB in size.

This is what I have in mind. Please let me know if this is a good idea for a Postgres production deployment.

I will get the below filesystems mounted with the following sizes.

/db ----> 50 GB

/db_data ---> 500 GB

I will initialize the database cluster in the custom location /db/postgres/pg11/data .

And right from the start I will start creating tablespaces like below

CREATE TABLESPACE orders_tbs LOCATION '/pgdata/<db_name>/orders_tbs';

and place business objects in these tablespaces like below

CREATE TABLE orders (id int, order_item text) tablespace orders_tbs;

postgresql

share

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

PostgreSQL version : 11.2

OS : RHEL or Oracle Linux 7.6 (Yet to be decided)

I am at the design stage of setting up a production database. In production, this DB size will be around 300GB to 400GB in size.

This is what I have in mind. Please let me know if this is a good idea for a Postgres production deployment.

I will get the below filesystems mounted with the following sizes.

/db ----> 50 GB

/db_data ---> 500 GB

I will initialize the database cluster in the custom location /db/postgres/pg11/data .

And right from the start I will start creating tablespaces like below

CREATE TABLESPACE orders_tbs LOCATION '/pgdata/<db_name>/orders_tbs';

and place business objects in these tablespaces like below

CREATE TABLE orders (id int, order_item text) tablespace orders_tbs;

postgresql

share

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

/db ----> 50 GB

/db_data ---> 500 GB

CREATE TABLESPACE orders_tbs LOCATION '/pgdata/<db_name>/orders_tbs';

CREATE TABLE orders (id int, order_item text) tablespace orders_tbs;

share

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 40 secs ago

Keith BrabantKeith Brabant

4

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 40 secs ago

Keith BrabantKeith Brabant

4