Skip site navigation (1) Skip section navigation (2)

Re: BUG #6186: out of memory while analyze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lampa <lampacz(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6186: out of memory while analyze
Date: 2011-08-31 21:11:50
Message-ID: 3940.1314825110@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Albert WardDate: 2011-09-01 01:07:26
Subject: The translation into Bulgarian
Previous:From: Srinivas AjiDate: 2011-08-31 09:59:18
Subject: BUG #6189: libpq: sslmode=require verifies server certificate if root.crt is present

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group