On 02/01/2019 23:53, Alexey Bashtanov wrote: >> In fact, maybe don't use the Portal structure at all and just store the >> saved textualized values inside postgres.c in a static variable. > > Unlike SQL, parameters may spend much more memory, so I'd have them > in portal memory context to make sure the memory is released earlier > rather than later.
Having them in the portal structure is different from having it in the portal memory context. Although there is perhaps value in keeping them together. > Do you think it would be acceptable to leave them cached in parameters > structure? Let's see how it looks. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
