Haroon good day Why can't I set work_mem with a value greater than 2Gb any restrictions for windows?
Also, the listening port of 2uda does not change even though the service is restarted in 2UDA any configuration after modifying the port in postgresql.conf? thanks El mié., 11 dic. 2019 a las 14:51, Haroon (<muhammad.har...@2ndquadrant.com>) escribió: > On Wed, 11 Dec 2019 at 17:10, Alvaro Herrera <alvhe...@2ndquadrant.com> > wrote: > > > > Hi Haroon > > > > We just got a report that with the 2UDA installer it is not possible to > > set work_mem to values higher than 2 GB. This is an expected limitation > > in 32bit builds, but surely 2UDA is a 64bit build? > > Yes, 2UDA uses 64bit build of PostgreSQL. > > Regards, > -- > Haroon http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > > > -- José Mercedes Venegas Acevedo cel Mov RPC 964185205
