tag:blogger.com,1999:blog-2047829934958115736.post5171793312952266269..comments2023-07-21T17:44:32.663+05:30Comments on Linux How - To's - Free Consultancy: Monitor PostgreSQL with Queriesmanish singhhttp://www.blogger.com/profile/01631053575099724221noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2047829934958115736.post-46582146748131208052011-08-24T06:28:31.000+05:302011-08-24T06:28:31.000+05:30Manish, do you have strong understanding of postgr...Manish, do you have strong understanding of postgresql shared buffers? Just looking to understand it thoroughly.sidharthhttp://na/noreply@blogger.comtag:blogger.com,1999:blog-2047829934958115736.post-89361444426014728972011-08-24T09:32:51.000+05:302011-08-24T09:32:51.000+05:30@sidharth:That i know and starts thing about Share...@sidharth:<br>That i know and starts thing about Shared Buffers, is this used for cache and write... mean, in terms of postgresql, it holds a block of memory, to hold data (from Disk to shared buffers) that has to read/write and then again sync back them to disk.manish singhhttp://www.blogger.com/profile/01631053575099724221noreply@blogger.comtag:blogger.com,1999:blog-2047829934958115736.post-75471432839999589722011-08-25T04:51:43.000+05:302011-08-25T04:51:43.000+05:30Yes, not sure why many documents say its so hard t...Yes, not sure why many documents say its so hard to set and configure. Do we need an increased level of understanding on how it works? Just looking for some help on how this is configured for enterprise level databases like the one i use.Sidharthhttp://na/noreply@blogger.comtag:blogger.com,1999:blog-2047829934958115736.post-84059420102788513772011-08-25T08:26:11.000+05:302011-08-25T08:26:11.000+05:30But i am sure, normal tuning can be done according...But i am sure, normal tuning can be done according to your server RAM config and usability. Issue occur when, the DB Server are in high need of tuning. Like your server is having high numbers of reads/writes and experiencing load on server, disk business etc... in this case, SHARED BUFFERS can play a vital role in performance boost. Other tuning are also required with shared buffers, like, <br><br>effective_cache_size<br>enable_seqscan<br>enable_indexscan<br>work_mem<br>maintenance_work_mem<br>max_connections <br><br>and many.. others depending environment need.manish singhhttp://www.blogger.com/profile/01631053575099724221noreply@blogger.com