Re: Tablespace storage bug...
| От | David G. Johnston |
|---|---|
| Тема | Re: Tablespace storage bug... |
| Дата | |
| Msg-id | CAKFQuwan5BGV+irGebgKYCiTTdmX_xq-p6rAyXdw_fJaezP9Uw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Tablespace storage bug... (Greg Kemnitz <gjkemnitz@gmail.com>) |
| Ответы |
Re: Tablespace storage bug...
|
| Список | pgsql-bugs |
On Wednesday, December 4, 2024, Greg Kemnitz <gjkemnitz@gmail.com> wrote:
In PG version 16.6.1.pgdg24.04+1 on Ubuntu:CREATE TABLE xxx (a int, b int, PRIMARY KEY (a)) TABLESPACE xyz;will store the table's base storage in xyz, but will store the table's PRIMARY KEY storage in pg_default.This seems a weird behavior and caused a load of a six billion row table to crash as the / partition unexpectedly ran out of space.Workaround:
Read the docs for the “using index tablespace” clause.
David J.
В списке pgsql-bugs по дате отправления: