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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
