how to create tablespace with set initial size in Postgresql?

Question

I have, in oracle, this following sql command to create a tablespace with initial size:

CREATE TABLESPACE tb1 DATAFILE 'file.f' SIZE 10M AUTOEXTEND ON;

I didn't find the same sql command for Postgresql.

According to my research there is't a possibility to set this field in postgres.

I need to set it because it increases the performance of my application.

user330315 · Accepted Answer · 2015-06-04 13:44:47Z

4

In short: you can't

The way Oracle stores data is completely different to the way Postgres does it. Postgres doesn't store everything in a single (tablespace) file the way Oracle does it.

A tablespace is not a file as in Oracle it's just a directory where Postgres stores the files for tables located in that tablespace. And because it's just a directory "pointer", there is no initial size you can specify.

answered Jun 4, 2015 at 13:44

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create tablespace with set initial size in Postgresql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related