[COMMITTERS] pgsql: Improve the situation for parallel query versus temp relations.

2016-06-09 Thread Tom Lane
Improve the situation for parallel query versus temp relations. Transmit the leader's temp-namespace state to workers. This is important because without it, the workers do not really have the same search path as the leader. For example, there is no good reason (and no extant code either) to prev

Re: [HACKERS] Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold

2016-06-09 Thread Robert Haas
On Thu, Jun 9, 2016 at 10:28 AM, Kevin Grittner wrote: > [Thanks to Robert to stepping up to keep this moving while I was > down yesterday with a minor injury. I'm back on it today.] >> Generally, I think I see the hazard you're concerned about: I had >> failed to realize, as you mentioned upthre

[COMMITTERS] pgsql: Repair a bit of pgindent damage.

2016-06-09 Thread Robert Haas
Repair a bit of pgindent damage. Inserting line-breaks into the middle of a URL is, to put it mildly, not very helpful, so persuade pgindent to leave it alone. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2410a2543e77983dab1f63f48b2adcd23dba994e Modified Files --

[COMMITTERS] pgsql: pgindent run for 9.6

2016-06-09 Thread Robert Haas
pgindent run for 9.6 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4bc424b968058c7f0aa685821d7039e86faac99c Modified Files -- contrib/auto_explain/auto_explain.c| 26 +- contrib/bloom/blinsert.c | 10 +- contrib

[COMMITTERS] pgsql: Update pgrowlocks extension for parallel query.

2016-06-09 Thread Robert Haas
Update pgrowlocks extension for parallel query. The pgrowlocks function provided by this extension is PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9164deea2f4ac90ee5e008ff41fc5ad4423887b2 Modified Files -- contrib/pgro

[COMMITTERS] pgsql: Update pg_buffercache extension for parallel query.

2016-06-09 Thread Robert Haas
Update pg_buffercache extension for parallel query. The pg_buffercache_pages function provided by this extension is PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/06d7fd6e2975db3273b14116a471f71fef9e0102 Modified Files -

[COMMITTERS] pgsql: Update pg_freespacemap extension for parallel query.

2016-06-09 Thread Robert Haas
Update pg_freespacemap extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/42d4257a069584e205cafcc175f9f6f8d673237c Modified Files -- contrib/pg_frees

[COMMITTERS] pgsql: Update pageinspect extension for parallel query.

2016-06-09 Thread Robert Haas
Update pageinspect extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e3b607cd7a949958bdccb056b5c3cb2389f588ad Modified Files -- contrib/pageinspect/

[COMMITTERS] pgsql: Update pgcrypto extension for parallel query.

2016-06-09 Thread Robert Haas
Update pgcrypto extension for parallel query. All functions provided by this extension are PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0dbf3ce0e0c0bac2eb84eec70bcd3d728abd5a8c Modified Files -- contrib/pgcrypto/Makefi

[COMMITTERS] pgsql: Update pg_prewarm extension for parallel query.

2016-06-09 Thread Robert Haas
Update pg_prewarm extension for parallel query. The pg_prewarm function provided by this extension is PARALLEL SAFE. Andreas Karlsson Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/6b3586caa810529635a8f77789d88e957b389469 Modified Files -- contrib/pg_p

[COMMITTERS] pgsql: Handle contrib's GIN/GIST support function signature changes hon

2016-06-09 Thread Tom Lane
Handle contrib's GIN/GIST support function signature changes honestly. In commits 9ff60273e35cad6e and dbe2328959e12701 I (tgl) fixed the signatures of a bunch of contrib's GIN and GIST support functions so that they would pass validation by the recently-added amvalidate functions. The backend doe

Re: [COMMITTERS] pgsql: Don't generate parallel paths for rels with parallel-restricted

2016-06-09 Thread Tom Lane
Robert Haas writes: > Don't generate parallel paths for rels with parallel-restricted outputs. Surely this bit is wrong on its face: @@ -971,6 +980,7 @@ set_append_rel_size(PlannerInfo *root, RelOptInfo *rel, adjust_appendrel_attrs(root, (Node *) re

[COMMITTERS] pgsql: Don't generate parallel paths for rels with parallel-restricted

2016-06-09 Thread Robert Haas
Don't generate parallel paths for rels with parallel-restricted outputs. Such paths are unsafe. To make it cheaper to detect when this case applies, track whether a relation's default PathTarget contains any non-Vars. In most cases, the answer will be no, which enables us to determine cheaply th

[COMMITTERS] pgsql: Yet again update typedefs.list file in preparation for pgindent

2016-06-09 Thread Robert Haas
Yet again update typedefs.list file in preparation for pgindent run Because the run was delayed, the file had a chance to get out of date. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e7bcd983f56136a9580076b60d5c19eb2fd83301 Modified Files -- src/tool

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Clarify documentation of ceil/ceiling/floor functions.

2016-06-09 Thread Tom Lane
Clarify documentation of ceil/ceiling/floor functions. Document these as "nearest integer >= argument" and "nearest integer <= argument", which will hopefully be less confusing than the old formulation. New wording is from Matlab via Dean Rasheed. I changed the pg_description entries as well as t

[COMMITTERS] pgsql: Mop-up for parallel degree-ectomy.

2016-06-09 Thread Tom Lane
Mop-up for parallel degree-ectomy. Fix a couple of overlooked uses of "degree" terminology. Make the parallel worker count selection logic in create_plain_partial_paths more robust (in particular, it failed with max_parallel_workers_per_gather set to zero). Branch -- master Details ---

Re: [HACKERS] Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold

2016-06-09 Thread Kevin Grittner
[Thanks to Robert to stepping up to keep this moving while I was down yesterday with a minor injury. I'm back on it today.] On Wed, Jun 8, 2016 at 3:11 PM, Robert Haas wrote: > On Wed, Jun 8, 2016 at 4:04 PM, Kevin Grittner wrote: >> -- connection 1 >> drop table if exists t1; >> create table

[COMMITTERS] pgsql: Eliminate "parallel degree" terminology.

2016-06-09 Thread Robert Haas
Eliminate "parallel degree" terminology. This terminology provoked widespread complaints. So, instead, rename the GUC max_parallel_degree to max_parallel_workers_per_gather (leaving room for a possible future GUC max_parallel_workers that acts as a system-wide limit), and rename the parallel_degr