Movatterモバイル変換


[0]ホーム

URL:


Quick Links

ALTER INDEX ... ALTER COLUMN not present in dump

From:Ronan Dunklau <ronan(dot)dunklau(at)people-doc(dot)com>
To:pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject:ALTER INDEX ... ALTER COLUMN not present in dump
Date:2018-11-15 10:23:24
Message-ID:CAARsnT3UQ4V=yDNW468w8RqHfYiY9mpn2r_c5UkBJ97NAApUEw@mail.gmail.com
Views:Whole Thread |Raw Message |Download mbox |Resend email
Thread:
Lists:pgsql-bugspgsql-hackers

Hello,

It seems like ALTER INDEX ... ALTER COLUMN statements (for setting specific
statistics targets on functional indexes, for example) are not part of a
pg_dump.

It is not easily noticed, since everything seems to work normally until a
sub-par plan is chosen because of an error in cardinality estimates.

Regards,

--
Ronan Dunklau

Responses

Browse pgsql-bugs by date

 FromDateSubject
Next MessageSergei Kornilov2018-11-15 10:44:42Re: ALTER INDEX ... ALTER COLUMN not present in dump
Previous MessageYogesh2018-11-15 07:15:30Re: BUG #15508: Not able to connect irrespective of valid entries in pg_hba.conf

Browse pgsql-hackers by date

 FromDateSubject
Next MessageJohn Naylor2018-11-15 10:25:21Re: [RFC] Removing "magic" oids
Previous MessageAmit Kapila2018-11-15 10:11:03Re: reloption to prevent VACUUM from truncating empty pages at the end of relation

[8]ページ先頭

©2009-2025 Movatter.jp