any issue with enable_partitionwise_join at instance level?

2020-10-11 Thread Ayub M
Hello, while running aggregate queries on partitioned table there is
improvement when enable_partitionwise_join is turned on. By default this
parameter is disabled and going by the documentation it says (
https://www.postgresql.org/docs/11/runtime-config-query.html)

```
Because partitionwise grouping or aggregation can use significantly more
CPU time and memory during planning, the default is off.
```

Why would it take "significantly" more CPU and memory for the planner? Is
there any foreseeable issues when enabling this at the instance level?


Re: rum index supported on pg13?

2020-10-11 Thread Michael Paquier
On Thu, Oct 08, 2020 at 09:29:31PM -0500, John the Scott wrote:
> will rum index from postgrespro be supported in pg13?
> numerous errors occur when compiling rum in pg13 and
> no replies from github.  the differences from pg12
> to pg13 seem to be significant
> 
>  https://github.com/postgrespro/rum

Did you ask directly this question to the authors of the extension on
the page of the project you are quoting above?
--
Michael


signature.asc
Description: PGP signature


Call for translations

2020-10-11 Thread Peter Eisentraut

Hello,

I would like to remind everyone about the PostgreSQL message translation 
effort and invite those capable of contributing to join in.  Several 
once-well maintained languages have fallen by the wayside a bit lately, 
and of course there is always the possibility of starting a new language 
or reviewing and revising work in existing languages.


If you want to help, see  for status, 
instructions, and other information.  If there are already active 
translation teams, please communicate with them first.  The mailing list

 is available for general
discussion and coordination of translation activities.

The time is now.  Even though PostgreSQL 13 was just released, 
translation updates for the PostgreSQL 13 stable branch are still welcome.


--
Peter Eisentraut  http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services