Re: Tamaño maximo para parametro work_mem sobre windows

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(dot)haroon(at)2ndquadrant(dot)com>)
escribió:

> On Wed, 11 Dec 2019 at 17:10, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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