Postgres Pro
Downloads
Home   >   mailing lists

Re: Tablespace storage bug... - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Tablespace storage bug...
Date
Msg-id CAKFQuwan5BGV+irGebgKYCiTTdmX_xq-p6rAyXdw_fJaezP9Uw@mail.gmail.com
Whole thread Raw
In response to Tablespace storage bug...  (Greg Kemnitz <gjkemnitz@gmail.com>)
Responses Re: Tablespace storage bug...
List pgsql-bugs
Tree view
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 by date:

Previous
From: Greg Kemnitz
Date:
Subject: Tablespace storage bug...
Next
From: Greg Kemnitz
Date:
Subject: Re: Tablespace storage bug...