Re: PostgreSQL 8.0.6 crash - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL 8.0.6 crash
Date
Msg-id 2904.1139508797@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 8.0.6 crash  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: PostgreSQL 8.0.6 crash
Re: PostgreSQL 8.0.6 crash
List pgsql-hackers
"Mark Woodward" <pgsql@mohawksoft.com> writes:
> Again, regardless of OS used, hashagg will exceed "working memory" as
> defined in postgresql.conf.

So?  If you've got OOM kill enabled, it can zap a process whether it's
strictly adhered to work_mem or not.  The OOM killer is entirely capable
of choosing a victim process whose memory footprint hasn't changed
materially since it started (eg, the postmaster).
        regards, tom lane


pgsql-hackers by date:

Previous
From: korry
Date:
Subject: Re: pg_hba.conf alternative
Next
From: Rodrigo Hjort
Date:
Subject: Server Programming in C: palloc() and pfree()