From: pginfo <pginfo@t1.unisoftbg.com>
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: out of memory error
Date: Sat, 26 Mar 2005 11:49:22 +0100
Message-ID: <42453E32.7060206@t1.unisoftbg.com> (raw)
References: <4244DFFB.6090101@t1.unisoftbg.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pginfo@t1.unisoftbg.com
Subject: Re: out of memory error
In-Reply-To: <42453E32.7060206@t1.unisoftbg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox