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

Re: BUG #6186: out of memory while analyze

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
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-30 18:35:32
Message-ID: 4E5D2D74.1060100@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 30.08.2011 14:20, Lampa wrote:
> Trying analyze table (ANALYZE TABLE table or VACUUM ANALYZE table) with
> 3051316 rows (displayed size 2521MB in \dt+)
>
> Log:
> ...
>        Analyze: 2236767256 total in 279 blocks; 18080 free (423 chunks);
> 2236749176 used
 > ...

Hmm, that looks like a memory like in ANALYZE. What does the table look 
like? "\d table" would be helpful.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Isaac JuradoDate: 2011-08-30 18:53:46
Subject: Re: BUG #6185: Segmentation fault with NULL string columns
Previous:From: Heikki LinnakangasDate: 2011-08-30 18:33:17
Subject: Re: BUG #6187: Select query stuck

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