pgsql: Add simple test for physical replication of sequences.

2022-01-15 Thread Tom Lane
Add simple test for physical replication of sequences. AFAICS we had no coverage of this point except in the seldom-used, slated-for-removal standby_schedule test suite. Sequence updates are enough different from regular table updates that it seems worth covering them explicitly in src/test/recov

pgsql: Remove standby_schedule and associated test files.

2022-01-15 Thread Tom Lane
Remove standby_schedule and associated test files. Since this test schedule is not run by default, it's next door to unused. Moreover, its test coverage is very thin, and what there is is just about entirely superseded by the src/test/recovery tests. Let's drop it instead of carrying obsolete tes

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t

pgsql: Build inherited extended stats on partitioned tables

2022-01-15 Thread Tomas Vondra
Build inherited extended stats on partitioned tables Commit 859b3003de disabled building of extended stats for inheritance trees, to prevent updating the same catalog row twice. While that resolved the issue, it also means there are no extended stats for declaratively partitioned tables, because t