Re: Running out of memory on vacuum

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Running out of memory on vacuum
Date: 2013-05-14 21:32:44
Message-ID: 5192AD7C.6070505@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 I would like to know your point of view at a first sight...

how many 100s of CPU cores do you have to execute those 1000+ concurrent
transactions?

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-05-14 21:42:36 Re: In what situations do you use -U of initdb?
Previous Message John R Pierce 2013-05-14 21:32:08 Re: How to convert numbers into words in postgresql