Обсуждение: Memory leak detected

Поиск
Список
Период
Сортировка

Memory leak detected

От
Diego Zuccato
Дата:
Hello.

I found that strange behaviour:

gsbusb=# select g.cod, (select count(*) from scatt where grotta=g.cod)
as att, count(*) from grotte g, immagine i, scatt a where
i.scattata_in=g.cod group by g.cod, att;
NOTICE:  PortalHeapMemoryFree: 0x0x8233790 not in alloc set!
NOTICE:  Buffer Leak: [056] (freeNext=-3, freePrev=-3, relname=scatt,
blockNum=0, flags=0x4, refcount=-2 -1)
 cod | att | count
-----+-----+-------
   3 |   1 |     2
 140 |   0 |    36
 187 |   0 |    32
 270 |   0 |     2
 271 |   0 |    34
 272 |   0 |    18
 273 |   0 |    26
(7 rows)

Hope it's useful info. If you need more, please mail me (I'm not
subscribed).

Tks for the wonderful product!

BYtE,
 Diego.

Re: Memory leak detected

От
Tom Lane
Дата:
Diego Zuccato <diego@otello.alma.unibo.it> writes:
> NOTICE:  PortalHeapMemoryFree: 0x0x8233790 not in alloc set!

I'd suggest updating to a newer version of Postgres.  That's got to be
7.0 or older.

            regards, tom lane