Re: pgsql: Allow concurrent-safe open() and fopen() in frontend code for Wi

2018-09-14 Thread Michael Paquier
On Fri, Sep 14, 2018 at 11:22:55AM -0400, Tom Lane wrote: > I'm surprised you didn't back-patch this --- isn't it a bug fix? > > A compromise might be to push it to v11 but not further. Yes, that's clearly a bug fix from pg_ctl point of view with TAP tests. However, I have rather cold feet about

pgsql: Move PartitionDispatchData struct definition to execPartition.c

2018-09-14 Thread Alvaro Herrera
Move PartitionDispatchData struct definition to execPartition.c There's no reason to expose the struct definition, so don't. Author: Amit Langote Discussion: https://postgr.es/m/d3fa24c1-bc65-7133-81df-6474387cc...@lab.ntt.co.jp Branch -- REL_11_STABLE Details --- https://git.postgres

pgsql: Improve parallel scheduling logic in pg_dump/pg_restore.

2018-09-14 Thread Tom Lane
Improve parallel scheduling logic in pg_dump/pg_restore. Previously, the way this worked was that a parallel pg_dump would re-order the TABLE_DATA items in the dump's TOC into decreasing size order, and separately re-order (some of) the INDEX items into decreasing size order. Then pg_dump would d

pgsql: Fix ALTER/TYPE on columns referenced by FKs in partitioned table

2018-09-14 Thread Alvaro Herrera
Fix ALTER/TYPE on columns referenced by FKs in partitioned tables When ALTER TABLE ... SET DATA TYPE affects a column referenced by constraints and indexes, it drop those constraints and indexes and recreates them afterwards, so that the definitions match the new data type. The original code did

pgsql: Fix ALTER/TYPE on columns referenced by FKs in partitioned table

2018-09-14 Thread Alvaro Herrera
Fix ALTER/TYPE on columns referenced by FKs in partitioned tables When ALTER TABLE ... SET DATA TYPE affects a column referenced by constraints and indexes, it drop those constraints and indexes and recreates them afterwards, so that the definitions match the new data type. The original code did

pgsql: Order active window clauses for greater reuse of Sort nodes.

2018-09-14 Thread Andrew Gierth
Order active window clauses for greater reuse of Sort nodes. By sorting the active window list lexicographically by the sort clause list but putting longer clauses before shorter prefixes, we generate more chances to elide Sort nodes when building the path. Author: Daniel Gustafsson (with some ed

Re: pgsql: Allow concurrent-safe open() and fopen() in frontend code for Wi

2018-09-14 Thread Tom Lane
Michael Paquier writes: > Allow concurrent-safe open() and fopen() in frontend code for Windows I'm surprised you didn't back-patch this --- isn't it a bug fix? A compromise might be to push it to v11 but not further. regards, tom lane