Joe Sunday <[EMAIL PROTECTED]> writes:
> It'll take me a while to come up with a dataset I can distribute that
> causes it. My first pass at fake random data didn't seem to trigger it,
> and I can't divulge the real data.
> I can poke with gdb, is there a guide for what to look for somewhere?
It
On Tue, Mar 14, 2006 at 11:13:38PM -0500, Tom Lane wrote:
> Joe Sunday <[EMAIL PROTECTED]> writes:
> > On Tue, Mar 14, 2006 at 03:56:51PM -0500, Tom Lane wrote:
> >> This error should result in dumping a list of per-context memory usage
> >> into the postmaster log ... could we have a look at that
Joe Sunday <[EMAIL PROTECTED]> writes:
> On Tue, Mar 14, 2006 at 03:56:51PM -0500, Tom Lane wrote:
>> This error should result in dumping a list of per-context memory usage
>> into the postmaster log ... could we have a look at that?
> Here you go:
> ...
> ExecutorState: -346079744 total in 476747
On Tue, Mar 14, 2006 at 03:56:51PM -0500, Tom Lane wrote:
> Joe Sunday <[EMAIL PROTECTED]> writes:
> > 8.1 grows until it uses about 4 GB, at which point it dies with the
> > following error:
> > ERROR: out of memory
> > DETAIL: Failed on request of size 8224.
>
> This error should result in du
Joe Sunday <[EMAIL PROTECTED]> writes:
> 8.1 grows until it uses about 4 GB, at which point it dies with the
> following error:
> ERROR: out of memory
> DETAIL: Failed on request of size 8224.
This error should result in dumping a list of per-context memory usage
into the postmaster log ... coul
I've got the following schema and identical data loaded
into both 7.4.12 and 8.1.3 running on Linux/Power5.
sort_mem/work_mem is 10240 on 7.4/8.1 respectively.
Table "public.a"
Column | Type | Modifiers
--++---
key_a
Bill - please cc: the bugs list too.
Lin, B (Bill) wrote:
Some more information please.
1. What operating-system?
XP SP2
2. Installed from a package (which) or source?
From package
3. What hangs - the client or the backend (or both)?
Both. The client is waiting for the backend's commit() to b
