Re: BUG #6186: out of memory while analyze

Lampa <lampacz(at)gmail(dot)com> writes:
> default_statistics_target = 8000 # range 1-10000

> Problem seems to be in default_statistics_target values from approx
> 6300. Up to 6300 analyze works but on another machine (64bit) works
> 10000 without problems on same but larger table (more data)

Well, there's a reason why the default value of that parameter is 100
and not 10000 ;-). The larger it is, the more memory space it's going
to take to do an ANALYZE. I don't see any bug here, you're just trying
to do more than you can do in a 32-bit machine.

I guess we could improve the documentation of default_statistics_target
to point out that it costs not only more time but more memory in
ANALYZE.

regards, tom lane