From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomeh, Husam <htomeh@firstam.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 0ut of Memory Error during Vacuum Analyze and
Date: Thu, 23 Feb 2006 17:46:59 -0500
Message-ID: <26905.1140734819@sss.pgh.pa.us> (raw)
In-Reply-To: <CB0FB369FF86E248A884BCC002562BCB010C0B60@pisgsna01sxch01.ana.firstamdata.com>
References: <CB0FB369FF86E248A884BCC002562BCB010C0B60@pisgsna01sxch01.ana.firstamdata.com>
"Tomeh, Husam" <htomeh@firstam.com> 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
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-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, htomeh@firstam.com
Subject: Re: 0ut of Memory Error during Vacuum Analyze and
In-Reply-To: <26905.1140734819@sss.pgh.pa.us>
* 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