Hey, You are using "WITH tablespace_option" wrong. Try it like this:
postgres=# CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION '/database' WITH (seq_page_cost=1.0,random_page_cost=4.0,effective_io_concurrency=1); CREATE TABLESPACE Cheers, Mateusz śr., 16 sie 2023 o 12:10 Amn Ojee Uw <amnoje...@gmail.com> napisał(a): > Hello children! > > I am learning how to create a tablespace, and AFAIK this are the steps to > follow. > > First step is to create the directory where the database files will be > created, for that I am using the root directory '/database'. This directory > is be owned by the postgres group. > > Example : > sudo mkdir /database > sudo chown postgres:postgres /database > > I read the following documentation > 1.) TABLESPACE > <https://www.postgresql.org/docs/current/sql-createtablespace.html> > > 2.) seq_page_cost > <https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-SEQ-PAGE-COST> > > 3.) effective_io_concurrency > <https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-EFFECTIVE-IO-CONCURRENCY> > > 4.) maintenance_io_concurrency > <https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-MAINTENANCE-IO-CONCURRENCY> > > 5.) Tablespaces > <https://www.postgresql.org/docs/current/manage-ag-tablespaces.html> > > x.) effective_io_concurrency > <https://manpages.debian.org/testing/manpages-dev/posix_fadvise.2.en.html> > > I then login PostgreSQL as so : sudo -u postgres psql. > > Note : *jamiil* is an actual account, it does exist! > > I proceed to create the 'TABLESPACE' using the default values in PostgreSQL > > CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION '/database' WITH > tablespace_option = seq_page_cost(1.0), random_page_cost (4.0), > effective_io_concurrency (1), maintenance_io_concurrency (10); > > But then I get this error message: > *ERROR: syntax error at or near "tablespace_option"* > *LINE 1: ...tablespace OWNER jamiil LOCATION '/database' WITH > tablespace...* > > What did I go wrong? > > This exercise is not imperative, but as a student of PostgreSQL I'd like > to try all there is to learn about PostgreSQL. > > Thanks in advance for your time and interest. >
