From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | "ray(dot)hammond77(at)gmail(dot)com" <ray(dot)hammond77(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Table-space documentation |
Date: | 2023-11-27 13:21:46 |
Message-ID: | CAKFQuwZBNXNgZbYKuDX-+wy9U1+ehxds4QvtUH_k3FKsQ2MgzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Sunday, November 26, 2023, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/manage-ag-tablespaces.html
> Description:
>
> While reading the table-space documentation
> https://www.postgresql.org/docs/16/manage-ag-tablespaces.html the
> information I was looking for was not included. The page invites feedback,
> so I though I would share. I was specifically looking for information on
> maximum table-space size and whether there is a use-case in which you would
> create several table-spaces to split your tables / indexes logically. I am
> from an Oracle world and it is normal for me to think about creating
> multiple table-spaces for groups of tables and placing a size on the
> table-space so that space does not extend and fill the o/s disk-space. It
> would be nice for the documentation to include information about this
> topic.
> Even if it is says that these factors I should not worry about as postgres
> handles them.
>
We tend to avoid documenting things that don’t exist. So the lack of a
documented limit or any syntax to define one means no limit exists.
As for usage patterns, there is a note I thought (maybe wiki FAQ?) that
since the only thing you get with a tablespace is another root level
storage place having more than one per disk really serves no purpose.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-11-27 13:37:24 | Re: [DOCS] Add example about date ISO format |
Previous Message | jian he | 2023-11-27 05:58:53 | Re: create table explicitly mention that unique|primary key constraint will create an |