Re: Limitation relates to memory allocation

2024-10-16 Thread David Rowley
On Mon, 14 Oct 2024 at 19:03, Ekaterina Kiryanova wrote: > Our research showed that the limit is imposed by the palloc() function, > regardless of whether it is a tuple or not, and if the data is > serialized or dumped, the effective limit can be even lower, typically > around 512MB per row. So fo

Re: Limitation relates to memory allocation

2024-10-16 Thread Peter Eisentraut
On 14.10.24 08:03, Ekaterina Kiryanova wrote: We encountered an issue related to internal memory allocation limit: ERROR: invalid memory alloc request size In the documentation on limits: https://www.postgresql.org/docs/17/ limits.html the description suggests that only a single field is limite

Limitation relates to memory allocation

2024-10-13 Thread Ekaterina Kiryanova
Hello! We encountered an issue related to internal memory allocation limit: ERROR: invalid memory alloc request size In the documentation on limits: https://www.postgresql.org/docs/17/limits.html the description suggests that only a single field is limited to 1GB, which could imply that the to