From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Alexey Bashtanov" <bashtanov(at)imap(dot)cc> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4513: VACUUM FULL fails with "out of memory" error |
Date: | 2008-11-05 22:12:44 |
Message-ID: | 87y6zxakkj.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Alexey Bashtanov" <bashtanov(at)imap(dot)cc> writes:
> The following bug has been logged online:
>
> Bug reference: 4513
> Logged by: Alexey Bashtanov
> Email address: bashtanov(at)imap(dot)cc
> PostgreSQL version: 8.3.1
> Operating system: Red Hat Linux 2.6.20-1.2320.fc5smp i686
> Description: VACUUM FULL fails with "out of memory" error
Are you sure this is 8.3.1 and not 8.3.0? There is a bug fixed in 8.3.1 which
sounds a lot like this:
Another VACUUM FULL bug introduced in 8.3 could result in a crash or
out-of-memory report when dealing with pages containing no live tuples.
> Here's the part of serverlog:
> ==========
> TopMemoryContext: 49416 total in 6 blocks; 8776 free (46 chunks); 40640
> used
> TopTransactionContext: 2986336304 total in 367 blocks; 192312 free (1088
> chunks); 2986143992 used
It does look like you have a memory leak in VACUUM FULL. There have been three
memory leaks fixed in bug-fix releases since 8.3.1 but none should be related
to VACUUM FULL.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-11-05 23:56:43 | Re: BUG #4513: VACUUM FULL fails with "out of memory" error |
Previous Message | Alexey Bashtanov | 2008-11-05 21:06:06 | BUG #4513: VACUUM FULL fails with "out of memory" error |