Message-ID: <42453E32.7060206@t1.unisoftbg.com>
Date: Sat, 26 Mar 2005 11:49:22 +0100
From: pginfo <pginfo@t1.unisoftbg.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.1) Gecko/20020823 Netscape/7.0
MIME-Version: 1.0
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: out of memory error
References: <4244DFFB.6090101@t1.unisoftbg.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi,
I send some additional info :


pginfo wrote:sklad05=# explain analyze select 
S.IDS_NUM,S.IDS_SKLAD,SUM(S.KOL),S.sernum FROM A_GAR_PROD_R S where ids 
< 9742465 GROUP BY S.IDS_NUM,S.IDS_SKLAD ,s.sernum limit 10;
                                                                             
QUERY 
PLAN                                                                             

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=82281.59..82281.61 rows=10 width=148) (actual 
time=9373.301..9373.368 rows=10 loops=1)
   ->  HashAggregate  (cost=82281.59..82594.48 rows=125156 width=148) 
(actual time=9373.294..9373.328 rows=10 loops=1)
         ->  Index Scan using a_gar_prod_r_pkey on a_gar_prod_r s  
(cost=0.00..69766.02 rows=1251557 width=148) (actual 
time=16.412..4175.948 rows=1237554 loops=1)
               Index Cond: (ids < 9742465)
 Total runtime: 9386.082 ms
(5 rows)

sklad05=# explain analyze select 
S.IDS_NUM,S.IDS_SKLAD,SUM(S.KOL),S.sernum FROM A_GAR_PROD_R S where ids 
< 9742466 GROUP BY S.IDS_NUM,S.IDS_SKLAD ,s.sernum limit 10;
ERROR:  out of memory
DETAIL:  Failed on request of size 344.
sklad05=# explain analyze select 
S.IDS_NUM,S.IDS_SKLAD,SUM(S.KOL),S.sernum FROM A_GAR_PROD_R S where ids 
 >= 9742466 GROUP BY S.IDS_NUM,S.IDS_SKLAD ,s.sernum limit 10;
                                                                          
QUERY 
PLAN                                                                           

---------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=7747.82..7747.84 rows=10 width=148) (actual 
time=960.984..961.050 rows=10 loops=1)
   ->  HashAggregate  (cost=7747.82..7777.27 rows=11783 width=148) 
(actual time=960.979..961.011 rows=10 loops=1)
         ->  Index Scan using a_gar_prod_r_pkey on a_gar_prod_r s  
(cost=0.00..6569.60 rows=117822 width=148) (actual time=0.874..431.357 
rows=131824 loops=1)
               Index Cond: (ids >= 9742466)
 Total runtime: 961.283 ms
(5 rows)

regards,
ivan.

> Hi ,
> I try to make insert into myTable select .... on pg 8.0.1 and freeBSD 
> 5.3.
> After ~10 sec. pg returns "out of memory".
>
> In log file I found:
>
> Portal hash: 8192 total in 1 blocks; 2008 free (0 chunks); 6184 used
> Relcache by OID: 8192 total in 1 blocks; 4040 free (0 chunks); 4152 used
> Relcache by name: 24576 total in 2 blocks; 13240 free (5 chunks); 
> 11336 used
> LockTable (locallock hash): 8192 total in 1 blocks; 4056 free (0 
> chunks); 4136 u
> sed
> ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
> ERROR:  out of memory
> DETAIL:  Failed on request of size 340.
>
> I have 2Gb RAM on this box.
>
> regards,
> ivan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>