Re: ALTER TABLE ... SET STORAGE does not propagate to indexes - Mailing list pgsql-hackers

From Adam Brusselback
Subject Re: ALTER TABLE ... SET STORAGE does not propagate to indexes
Date
Msg-id CAMjNa7eGGceyHROFSwXUtZB8dz2zUFrbU_=CJUqY-Z2QrBB-nw@mail.gmail.com
Whole thread Raw
In response to Re: ALTER TABLE ... SET STORAGE does not propagate to indexes  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
> ALTER TABLE ... SET STORAGE does not propagate to indexes, even though
> indexes created afterwards get the new storage setting.  So depending on
> the order of commands, you can get inconsistent storage settings between
> indexes and tables.

I've absolutely noticed this behavior, I just thought it was intentional for some reason.

Having this behavior change as stated above would be very welcome in my opinion. It's always something i've had to manually think about in my migration scripts, so it would be welcome from my view.

-Adam

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Make autovacuum sort tables in descending order of xid_age
Next
From: Tom Lane
Date:
Subject: Re: snapper vs. HEAD