Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc() - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()
Date
Msg-id 199909270033.UAA26937@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()  ("Tim Joyce" <tim@hoop.co.uk>)
List pgsql-general
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> sorry, forgot to add:
>
> I have just deleted 1,200,000 records

It will be faster to dump out the table and reload.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Any books available commercially?
Next
From: "Simon Kwan"
Date:
Subject: Help: Choosing PostgreSQL vs MySQL