![]() ![]() This may be useful if one tablespace is located on a disk which is faster or slower than the remainder of the I/O subsystem. Setting these values for a particular tablespace will override the planner's usual estimate of the cost of reading pages from tables in that tablespace, and the executor's prefetching behavior, as established by the configuration parameters of the same name (see seq_page_cost, random_page_cost, effective_io_concurrency, maintenance_io_concurrency). Currently, the only available parameters are seq_page_cost, random_page_cost, effective_io_concurrency and maintenance_io_concurrency. To create a true read-only user with PostgreSQL 9. tablespace_optionĪ tablespace parameter to be set or reset. In PostgreSQL, the CREATE TABLE clause as the name suggests is used to create new tables. The directory must be specified by an absolute path name. The directory must exist ( CREATE TABLESPACE will not create it), should be empty, and must be owned by the PostgreSQL system user. The directory that will be used for the tablespace. Only superusers can create tablespaces, but they can assign ownership of tablespaces to non-superusers. If omitted, defaults to the user executing the command. The name of the user who will own the tablespace. To create a new table, you use the CREATE TABLE statement. The name cannot begin with pg_, as such names are reserved for system tablespaces. Open the table (or refresh the window if the table was already open) to see the data.The name of a tablespace to be created. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |