Re: Memory and/or cache issues? - Mailing list pgsql-performance

From mcelroy, tim
Subject Re: Memory and/or cache issues?
Date
Msg-id 0C4841B42F87D51195BD00B0D020F5CB044B260B@MORPHEUS
Whole thread Raw
In response to Memory and/or cache issues?  ("mcelroy, tim" <tim.mcelroy@bostonstock.com>)
Responses Re: Memory and/or cache issues?
List pgsql-performance

Thanks Tom.  I thought the same thing and waded through the archives trying various fixes such as vacuum, vacuum full (both with analyze), reindex and still the same issue.  However, once the box was rebooted the backup went smooth and the data was fine.  We have two (2) machines (PROD001 & PROD002) that are "in-sync" and the data matched exactly.  PROD002 was where I had the problem.  I see this on all the postgres installations, no matter what I set the postgresql.conf settings to regarding memory allocation, once postgres starts up 95% of the memory on the box is used.  Is there a way within Linux to 'see' what or who is actually using this memory?  I would love to say it's a hardware thing and that postgres is fine :)

Regards,
Tim

 -----Original Message-----
From:   Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent:   Friday, May 05, 2006 9:25 AM
To:     mcelroy, tim
Cc:     pgsql-performance@postgresql.org
Subject:        Re: [PERFORM] Memory and/or cache issues?

"mcelroy, tim" <tim.mcelroy@bostonstock.com> writes:
> pg_dump: ERROR:  invalid memory alloc request size 18446744073709551613

That looks more like a corrupt-data problem than anything directly to do
with having or not having enough memory.

                        regards, tom lane

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Memory and/or cache issues?
Next
From: Tom Lane
Date:
Subject: Re: Memory and/or cache issues?