--- On Mon, 2/15/10, Kenneth Marshall wrote:
> From: Kenneth Marshall
> Subject: Re: [ADMIN] AIX - Out of Memory
> To: "Tom Lane"
> Cc: "Thorne, Francis" , pgsql-admin@postgresql.org
> Date: Monday, February 15, 2010, 11:18 AM
> On Mon, Feb 15, 2010 at 10:57:06AM
> -0500, Tom Lane wrote:
> >
I am not sure where I should post this but I am running into problems trying
to restore a large table. I am running 8.4.1 on all servers. The table is
about 25gb in size and most of that is toasted. It has about 2.5m records.
When I dump this table using pg_dump -Fc it creates a 15 gb file. I am
tr
On Mon, Feb 15, 2010 at 10:57:06AM -0500, Tom Lane wrote:
> "Thorne, Francis" writes:
> > Looking for some help with regards to an 'Out of Memory' issue I have
> > with our Postgresql install on AIX. When running large updates or
> > select queries we get an out of memory error returned and detai
"Thorne, Francis" writes:
> Looking for some help with regards to an 'Out of Memory' issue I have
> with our Postgresql install on AIX. When running large updates or
> select queries we get an out of memory error returned and details
> entered in the log file like below. This is a 64-bit install
Hi All,
Looking for some help with regards to an 'Out of Memory' issue I have
with our Postgresql install on AIX. When running large updates or
select queries we get an out of memory error returned and details
entered in the log file like below. This is a 64-bit install and I have
set the ulimit
