X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C97E29DC819 for ; Thu, 23 Feb 2006 18:47:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86250-05 for ; Thu, 23 Feb 2006 18:47:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 83D179DC849 for ; Thu, 23 Feb 2006 18:46:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k1NMkxW1026906; Thu, 23 Feb 2006 17:46:59 -0500 (EST) To: "Tomeh, Husam" cc: pgsql-performance@postgresql.org Subject: Re: 0ut of Memory Error during Vacuum Analyze and In-reply-to: References: Comments: In-reply-to "Tomeh, Husam" message dated "Thu, 23 Feb 2006 14:42:07 -0800" Date: Thu, 23 Feb 2006 17:46:59 -0500 Message-ID: <26905.1140734819@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.111 required=5 tests=[AWL=0.111] X-Spam-Score: 0.111 X-Spam-Level: X-Archive-Number: 200602/378 X-Sequence-Number: 17364 "Tomeh, Husam" writes: > When I first connect to the database via "psql" and issue the "create > index" statement, of course, I get the "out of memory" error. If I > don't quit my current session and re-ran the same DDL statement again, > the index gets created successfully!.. However, if after my first > unsuccessful run, I exit my session and re-connect again, and then run > the DDL, it will fail again and get the same error. I have done that for > many times and appears to have a consistent pattern of behavior. Now that you know how to reproduce it, please have another go at getting that stack trace. The palloc printout certainly looks like some kind of memory-leak issue, but I can't tell more than that from it. regards, tom lane