a lot for your reply,
Ioana
- Original Message -
From: Scott Marlowe
To: Ioana Danes
Cc: Igor Neyman ; PostgreSQL General
Sent: Tuesday, May 14, 2013 6:16:38 PM
Subject: Re: [GENERAL] Running out of memory on vacuum
Meant to add: I'd definitely be looking at using pgbouncer if
Meant to add: I'd definitely be looking at using pgbouncer if you can
to pool locally. Makes a huge difference in how the machine behaves
should things go badly (i.e. it starts to slow down and connections
want to pile up)
On Tue, May 14, 2013 at 4:15 PM, Scott Marlowe wrote:
> On Tue, May 14, 20
On Tue, May 14, 2013 at 11:25 AM, Ioana Danes wrote:
> I agree and I will do.
> Now let me ask you this. How much memory would be decent you put on a server
> with 2000 users creating transactions every 4-10 seconds (2 to 20 inserts) at
> pick times? I know more should be considered when taking
On 5/14/2013 10:25 AM, Ioana Danes wrote:
I agree and I will do.
Now let me ask you this. How much memory would be decent you put on a server
with 2000 users creating transactions every 4-10 seconds (2 to 20 inserts) at
pick times? I know more should be considered when taking such decision but
at a first sight...
Thanks
- Original Message -
From: Scott Marlowe
To: Ioana Danes
Cc: Igor Neyman ; PostgreSQL General
Sent: Tuesday, May 14, 2013 1:04:06 PM
Subject: Re: [GENERAL] Running out of memory on vacuum
Well definitely look at getting more memory in it if you can. 8G is
Well definitely look at getting more memory in it if you can. 8G is
seriously pretty small.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
response,
ioana
- Original Message -
From: Scott Marlowe
To: Ioana Danes
Cc: Igor Neyman ; PostgreSQL General
Sent: Tuesday, May 14, 2013 12:14:18 PM
Subject: Re: [GENERAL] Running out of memory on vacuum
On Tue, May 14, 2013 at 8:30 AM, Ioana Danes wrote:
> Hi Igor,
>
> 1. I could remov
On Tue, May 14, 2013 at 8:30 AM, Ioana Danes wrote:
> Hi Igor,
>
> 1. I could remove the nightly vacuum but I think that is
> not the cause. The vacuum is only catching the problem. If I ignore the
> vacuum message for few days the system is gonna run out of memory on
> queries...
You should be
> -Original Message-
> From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca]
> Sent: Tuesday, May 14, 2013 11:29 AM
> To: Igor Neyman; PostgreSQL General
> Subject: Re: [GENERAL] Running out of memory on vacuum
>
>
>
> Hi Igor,
>
> I don't need t
nyhow at the time of the vacuum there is
nothing else going on on the database. Sales are off.
Thanks,
- Original Message -
From: Igor Neyman
To: Ioana Danes ; PostgreSQL General
Cc:
Sent: Tuesday, May 14, 2013 11:06:25 AM
Subject: Re: [GENERAL] Running out of memory on vacuum
&g
> -Original Message-
> From: Ioana Danes [mailto:ioanasoftw...@yahoo.ca]
> Sent: Tuesday, May 14, 2013 10:30 AM
> To: Igor Neyman; PostgreSQL General
> Subject: Re: [GENERAL] Running out of memory on vacuum
>
> Hi Igor,
>
> 1. I could remove the nightly vacu
...
Thanks for quick response,
- Original Message -
From: Igor Neyman
To: Ioana Danes ; PostgreSQL General
Cc:
Sent: Tuesday, May 14, 2013 10:11:19 AM
Subject: Re: [GENERAL] Running out of memory on vacuum
> Subject: [GENERAL] Running out of memory on vacuum
>
> Hi all,
>
> Subject: [GENERAL] Running out of memory on vacuum
>
> Hi all,
>
> I have a production database that sometimes runs out of memory=at
> nightly vacuum.
>
> The application runs typically with around 40 post=res connections but
> there are times when the connectio
Hi all,
I have a production database that sometimes runs out of
memory=at nightly vacuum.
The application runs typically with around 40 post=res
connections but there are times when the connections increase because =f some
queries going on. The reason is that the operations are slow, the t=rmin
14 matches
Mail list logo
