Tablespace storage bug...

From: Greg Kemnitz <gjkemnitz(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Tablespace storage bug...
Date: 2024-12-05 01:04:16
Message-ID: CAJm8+_HWqJO-Qbz1s+CsiCCQ6-cHLiUX2OKfhv=Q5XBnoKwJ5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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:

alter database abc set default_tablespace=xyz;
drop table xxx;
create table xxx;

will get all the data loaded to xxx - including the pk - stored in the
location for xyz.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2024-12-05 01:09:29 Re: Tablespace storage bug...
Previous Message PG Bug reporting form 2024-12-04 23:55:49 BUG #18734: pg_terminate_backend was unresponsive for processes with the status "active"