[COMMITTERS] Add optional JIT support for expression evaluation.

2017-04-01 Thread Andres Freund
Based on the infrastructure added in b8d7f053c5c2b, this allows expressions in expensive queries to be compiled to native code. In TPC-H this yields up to 40% of speedups. Whenever a query has a total cost over jit_expression_minimum, all expressions in it will be JIT compiled. That allows to pe

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Thomas Munro
On Sat, Apr 1, 2017 at 8:41 PM, Andres Freund wrote: > For the upcoming JIT support LLVM is required. To avoid issues with > having to support multiple LLVM versions, add a vendored version of > LLVM. > > The large size of LLVM makes this not great, but I think it's better > than the alternatives

Re: [COMMITTERS] pgsql: Try to fix breakage of sepgsql hooks by ENR patch.

2017-04-01 Thread Christoph Berg
Re: Kevin Grittner 2017-04-01 > Try to fix breakage of sepgsql hooks by ENR patch. > > Turned up by buildfarm animal rhinoceros. Fixing blind. Will have > to wait for next run by rhinoceros to know whether it worked. Fwiw, I was seeing sepgsql problems on Ubuntu xenial and trusty this morning

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Michael Paquier
On Sat, Apr 1, 2017 at 5:27 PM, Thomas Munro wrote: > On Sat, Apr 1, 2017 at 8:41 PM, Andres Freund wrote: >> For the upcoming JIT support LLVM is required. To avoid issues with >> having to support multiple LLVM versions, add a vendored version of >> LLVM. >> >> The large size of LLVM makes thi

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Robert Haas
On Sat, Apr 1, 2017 at 3:41 AM, Andres Freund wrote: > For the upcoming JIT support LLVM is required. To avoid issues with > having to support multiple LLVM versions, add a vendored version of > LLVM. > > The large size of LLVM makes this not great, but I think it's better > than the alternatives

Re: [COMMITTERS] Add optional JIT support for expression evaluation.

2017-04-01 Thread Simon Riggs
On 1 April 2017 at 08:41, Andres Freund wrote: > Originally slated for v11, discussions at pgconf.us convinced me to > add this to v10. +1 -- Simon Riggshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-commit

[COMMITTERS] pgsql: Write "waiting for checkpoint" on regular progress row

2017-04-01 Thread Magnus Hagander
Write "waiting for checkpoint" on regular progress row When reporting progress, make the "waiting for checkpoint" test be overwritten by the file-based progress once it's completed. This is more consistent with how we report the rest of the progress. Suggested by Jeff Janes Branch -- master

[COMMITTERS] pgsql: Back-patch checkpoint clarification docs and pg_basebackup updat

2017-04-01 Thread Magnus Hagander
Back-patch checkpoint clarification docs and pg_basebackup updates This backpatches 51e26c9 and 7220c7b, including both documentation updates clarifying the checkpoints at the beginning of base backups and the messages in verbose and progress mdoe of pg_basebackup. Author: Michael Banck Discussio

[COMMITTERS] pgsql: Back-patch checkpoint clarification docs and pg_basebackup updat

2017-04-01 Thread Magnus Hagander
Back-patch checkpoint clarification docs and pg_basebackup updates This backpatches 51e26c9 and 7220c7b, including both documentation updates clarifying the checkpoints at the beginning of base backups and the messages in verbose and progress mdoe of pg_basebackup. Author: Michael Banck Discussio

[COMMITTERS] pgsql: Back-patch checkpoint clarification docs and pg_basebackup updat

2017-04-01 Thread Magnus Hagander
Back-patch checkpoint clarification docs and pg_basebackup updates This backpatches 51e26c9 and 7220c7b, including both documentation updates clarifying the checkpoints at the beginning of base backups and the messages in verbose and progress mdoe of pg_basebackup. Author: Michael Banck Discussio

[COMMITTERS] pgsql: BRIN auto-summarization

2017-04-01 Thread Alvaro Herrera
BRIN auto-summarization Previously, only VACUUM would cause a page range to get initially summarized by BRIN indexes, which for some use cases takes too much time since the inserts occur. To avoid the delay, have brininsert request a summarization run for the previous range as soon as the first t

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Andres Freund
On 2017-04-01 10:21:27 -0400, Robert Haas wrote: > On Sat, Apr 1, 2017 at 3:41 AM, Andres Freund wrote: > > For the upcoming JIT support LLVM is required. To avoid issues with > > having to support multiple LLVM versions, add a vendored version of > > LLVM. > > > > The large size of LLVM makes th

[COMMITTERS] pgsql: Fix expected output

2017-04-01 Thread Alvaro Herrera
Fix expected output Previous commit had a thinko in the expected output for new tests. Per buildfarm Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3a82129a40a3a2987356d4051e017fd456876c8d Modified Files -- src/test/regress/expected/brin.out | 2 +- 1 f

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Andres Freund
On 2017-04-01 21:27:42 +1300, Thomas Munro wrote: > On Sat, Apr 1, 2017 at 8:41 PM, Andres Freund wrote: > > For the upcoming JIT support LLVM is required. To avoid issues with > > having to support multiple LLVM versions, add a vendored version of > > LLVM. > > > > The large size of LLVM makes t

[COMMITTERS] pgsql: BRIN de-summarization

2017-04-01 Thread Alvaro Herrera
BRIN de-summarization When the BRIN summary tuple for a page range becomes too "wide" for the values actually stored in the table (because the tuples that were present originally are no longer present due to updates or deletes), it can be useful to remove the outdated summary tuple, so that a futu

Re: [COMMITTERS] pgsql: Full Text Search support for json and jsonb

2017-04-01 Thread Andrew Dunstan
On 03/31/2017 02:38 PM, Tom Lane wrote: > Andrew Dunstan writes: >> Full Text Search support for json and jsonb >> The new functions are ts_headline() and to_tsvector. > Should this not have included a catversion bump? > > Oops, you're right. I see there have been severa

[COMMITTERS] pgsql: Fix two undocumented parameters to functions from ENR patch.

2017-04-01 Thread Kevin Grittner
Fix two undocumented parameters to functions from ENR patch. On ProcessUtility document the parameter, to match others. On CreateCachedPlan drop the queryEnv parameter. It was not referenced within the function, and had been added on the assumption that with some unknown future usage of QueryEnv

Re: [COMMITTERS] Vendor LLVM 4.0.

2017-04-01 Thread Jan de Visser
On Saturday, April 1, 2017 3:01:18 PM EDT Andres Freund wrote: > On 2017-04-01 10:21:27 -0400, Robert Haas wrote: > > On Sat, Apr 1, 2017 at 3:41 AM, Andres Freund wrote: > > > For the upcoming JIT support LLVM is required. To avoid issues with > > > having to support multiple LLVM versions, add

[COMMITTERS] pgsql: Allow psql variable substitution to occur in backtick command st

2017-04-01 Thread Tom Lane
Allow psql variable substitution to occur in backtick command strings. Previously, text between backquotes in a psql metacommand's arguments was always passed to the shell literally. That considerably hobbles the usefulness of the feature for scripting, so we'd foreseen for a long time that we'd

Re: [COMMITTERS] pgsql: BRIN auto-summarization

2017-04-01 Thread Amit Kapila
On Sat, Apr 1, 2017 at 10:32 PM, Alvaro Herrera wrote: > BRIN auto-summarization > > > Most of the new code here is in autovacuum, which can now be told about > "work items" to process. > Nice framework! > This can be used for other things such as GIN > pending list cleaning, perhaps visibility