RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1

2020-02-19 Thread Bellrose, Brian
Thanks for the info. I will investigate these steps. Brian -Original Message- From: Giulio Calacoci Sent: Wednesday, February 19, 2020 9:07 AM To: Bellrose, Brian Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap

Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1

2020-02-19 Thread Giulio Calacoci
Hi, I'm not an OpenSuse expert, but I know a bit about building pglogical... I've been able to compile pglogical on a leap 42.3 docker image In the beginning, I tried to compile pglogical using the very same postgresql packages you were using, but for some reasons, I was consistently receiving l

Runtime partition pruning with hash partitioning

2020-02-19 Thread Pavel Luzanov
Hello, Runtime partition pruning don't work without index on a hash partitioned column. Consider this test case on version 12: create table data (   key_id    integer not null,   value real not null ) partition by hash(key_id); create table data_0 partition of data for values with (modulu