I replied to this a few days ago but forgot to include the group. It
appears that increasing our server swap space has fixed our problems. I
will keep my fingers crossed.
> > (there are currently a little over 200 active connections to the
> > database):
>
> How many cores do you have on the s
Hi,
On Tue, 13 Nov 2012, Aaron Bono wrote:
I have been struggling with an issue on our database server lately with
Postgres crashing our server by taking up too much RAM. To alleviate this
problem, I just upgraded from a 6 GB RAM server to a new 32 GB RAM server.
The new server is running Ubun
On Wed, Nov 14, 2012 at 3:51 PM, Fernando Hevia wrote:
>
>
>
> On Wed, Nov 14, 2012 at 2:30 AM, Aaron Bono wrote:
>>
>> On our old server, our hosting company said the server was running out of
>> RAM and then became unresponsive. I haven't checked about the new server
>> yet.
>
>
> Unresponsive
Hi -
Thank you Laurnez.
Ronit
On Fri, Nov 16, 2012 at 11:56 AM, Albe Laurenz wrote:
> Ronit Allen wrote:
> > On 9.1 with postgresql.conf left at defaults, what period of time does
> a query on pg_stat_all_tables
> > cover?
> >
> > Let's say my database has been running for exactly one year.
> >
Sorry, I forgot to mail to the list.
-- Forwarded message --
From: Aaron Bono
Date: Sun, Nov 18, 2012 at 3:24 AM
Subject: Fwd: [ADMIN] Postgre Eating Up Too Much RAM
To: Postgres
I replied to this a few days ago but forgot to include the group. It
appears that increasing our s
