=?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= <zeleny(dot)ales(at)gmail(dot)com> writes:
> the default statistics target is:
> 2500
> So I've changed it to the default:
> powa=# ALTER TABLE testcase_t3 ALTER COLUMN records SET STATISTICS 100;
> The memory consumption drops down to ~ 1.1GB
> So you were right, thanks!
Yeah, the array statistics collection code is a bit of a memory hog
compared to most other data types. I'm not sure that's a bug exactly;
there are more kinds of stats that we want to collect for arrays, such
as per-element stats.
regards, tom lane