help with a palloc error on FreeBSD

From: "Jeff Hoffmann" <jeff(at)remapcorp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: help with a palloc error on FreeBSD
Date: 1998-09-04 21:54:59
Message-ID: 000e01bdd84e$a9c21700$c525c4ce@go-to-jail.remapcorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'll ask this on a FreeBSD list as well, but I was wondering if any of you
might have some specific suggestions. Here's what's happening: I'm running
FreeBSD 2.2.5 and PostgreSQL 6.3.2. I have a table with about 1.3 million
rows and I'm trying to create an index on one of the fields (a box type)
using an rtree. About 45 minutes into it, I'm getting a fatal palloc error:

FATAL 1: palloc failure: memory exhausted

the first thing I did was bump up the swap space and tried it again. Same
result. Then I bumped up the process memory limits in the kernel (MAXDSIZE
and DFLDSIZE) to 256MB - 512MB, same thing happens. Then I actually
decided to investigate what was going on with top and vmstat; both show a
lot less memory being used that any of the initial memory limits.

Anybody have any idea what's going on and what settings I have to change?

Thanks,

jeff

Browse pgsql-general by date

  From Date Subject
Next Message Chris Hardie 1998-09-04 21:58:36 DBI w/Postgres
Previous Message Michael Meskes 1998-09-04 19:15:21 Re: [HACKERS] Re: CIDR/IP types. Was: [GENERAL] big numbers