Feature Requests

2020-10-25 Thread Nikolai Lusan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi, I was wondering where I can see open feature requests. One I would like to see is multi-master replication ... I did find a 2016 request that was marked as "planned", but to the best of my knowledge it hasn't made production yet. - -- Nikolai

Re: Feature Requests

2020-10-25 Thread Andreas Kretschmer
Am 25.10.20 um 10:26 schrieb Nikolai Lusan: -BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi, I was wondering where I can see open feature requests. One I would like to see is multi-master replication ... I did find a 2016 request that was marked as "planned", but to the best of my knowled

Re: Attaching database

2020-10-25 Thread Peter J. Holzer
On 2020-10-19 20:21:05 +0200, Pavel Stehule wrote: > po 19. 10. 2020 v 20:18 odesílatel Igor Korot napsal: > On Mon, Oct 19, 2020 at 12:51 PM Pavel Stehule > wrote: > > It is a different thing - postgresql_fdw does nested connect - it uses > > client-server protocol. > > >

Re: postgres materialized view refresh performance

2020-10-25 Thread Ayub M
Thank you both. As for the mview refresh taking long -- • The mview gets refreshed in a couple of mins sometimes and sometimes it takes hours. When it runs for longer, there are no locks and no resource shortage, the number of recs in the base table is 6m (7.5gb) which is not huge so why does it