On Fri, Feb 24, 2012 at 12:41 PM, Prashant Bharucha <prashantbharucha@xxxxxxxx> wrote: > > Hello All > > Could you please help to figure out how much maxium memory can allocated in Shared Memory on Debian 64 bit OS ? With appropriate shm settings, you can easily set it high enough to cause problems with swapping etc. I've successfully allocated 24G in testing on a machiine with 128G. However, in all the testing I did 8G was the point where we no longer got any performance increase. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general