tag:blogger.com,1999:blog-7476449567742726187.post8648506985639023325..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: Adjusting defaults for PostgreSQL.confJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-7476449567742726187.post-8050362703526437222013-11-08T10:17:35.912-08:002013-11-08T10:17:35.912-08:00Like anyone can keep track with that thread ...Like anyone can keep track with that thread ...Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-28622402029187158242013-11-07T09:31:26.978-08:002013-11-07T09:31:26.978-08:00I think the effective_cache_size is 4x shared buf...I think the effective_cache_size is 4x shared buffers, but might be 3x by the time 9.4 is released. I think you stated this backwards above.Bruce Momjianhttps://www.blogger.com/profile/07875088787463864011noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-50017938982361152402013-10-21T18:06:40.881-07:002013-10-21T18:06:40.881-07:00Actually, that's accounted for in the existing...Actually, that's accounted for in the existing tunable variables. However, that does bring up an important point for any autotuning.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-16991906621821207602013-10-21T17:33:21.171-07:002013-10-21T17:33:21.171-07:00This comment has been removed by the author.Guido Stepkenhttps://www.blogger.com/profile/08304321705611519794noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-83777037579007913962013-10-21T17:32:34.798-07:002013-10-21T17:32:34.798-07:00With beginning of SSDs doing random lookups at a r...With beginning of SSDs doing random lookups at a rate of even 15.000/second one can expect to get at minimum a thousand lookups even without large ram buffers. But therefore PostgreSQL algorithms have slighty to be changed.Guido Stepkenhttps://www.blogger.com/profile/08304321705611519794noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-59991512876018047362013-10-20T11:20:07.194-07:002013-10-20T11:20:07.194-07:00confirmed. Mind you, caching is being wonky in th...confirmed. Mind you, caching is being wonky in this instance, but the web team is on it.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-69096483418977523812013-10-19T09:32:29.256-07:002013-10-19T09:32:29.256-07:00Check out lowendbox.com and the like for the truly...Check out lowendbox.com and the like for the truly low end. The smallest I've ever noticed is 64M, but usually 128M is lowest. However, the nature of the task likely changes for these.Anonymoushttps://www.blogger.com/profile/17732261533947236572noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-39788680914912799082013-10-18T17:17:58.389-07:002013-10-18T17:17:58.389-07:00I don't know the user base, but the smallest A...I don't know the user base, but the smallest Amazon EC2 server (the "micro" instances) have 615MB of RAM, and the smallest server offered by RackSpace have 512MB of RAM.Software and Motorcycleshttps://www.blogger.com/profile/05788952289316710578noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-32660259627216253522013-10-18T15:17:18.517-07:002013-10-18T15:17:18.517-07:00I think you're seeing the effect of server-sid...I think you're seeing the effect of server-side caching.Josh Berkushttps://www.blogger.com/profile/09671139717468724246noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-2109192396163401712013-10-18T14:17:19.468-07:002013-10-18T14:17:19.468-07:00Your survey may not be working correctly. I voted...Your survey may not be working correctly. I voted in the 4 - 7 category. My vote didn't show up there. There were only 2 results. One in 1 - 1.9 and the other in 8GB and up. James Hubbardhttps://www.blogger.com/profile/17473850116716731438noreply@blogger.com