User Tools

Site Tools


ramfs_based_table_space

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
ramfs_based_table_space [2012/03/23 15:41]
k2patel [Automating the process]
ramfs_based_table_space [2012/03/23 15:41]
k2patel [Setting up a tablespace]
Line 8: Line 8:
  
  
-    ​Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files \\ +Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files \\ 
-    representing database objects can be stored. Once created, a tablespace can be referred to by name when creating \\ +representing database objects can be stored. Once created, a tablespace can be referred to by name when creating \\ 
-    database objects.The location must be an existing, empty directory that is owned by the PostgreSQL system user. \\ +database objects.The location must be an existing, empty directory that is owned by the PostgreSQL system user. \\ 
-    All objects subsequently created within the tablespace will be stored in files underneath this directory. \\ +All objects subsequently created within the tablespace will be stored in files underneath this directory. \\ 
-    Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary \\ +Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary \\ 
-    database users to make use of it. To do that, grant them the CREATE privilege on it. +database users to make use of it. To do that, grant them the CREATE privilege on it. 
  
 First create the directory where tablespace will be stored. It must reside on your ramfs filesystem. First create the directory where tablespace will be stored. It must reside on your ramfs filesystem.
ramfs_based_table_space.txt · Last modified: 2012/03/23 15:42 by k2patel