Re: [GENERAL] Shared Buffers

On Mon, Mar 2, 2009 at 7:40 AM, Gauthier, Dave wrote: > I believe that op system side buffering can play a role too.  I our case, > the DB server (machine & op sys) caches data that it pulled from disk (not > necessarily from a DB) and also the disk servers do the same.  If a block > was removed f

Re: [GENERAL] Shared Buffers

dave From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Siddharth Shah Sent: Monday, March 02, 2009 8:12 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Shared Buffers Hello All, How Postgres Maintains data in Shared Buffer

Re: [GENERAL] Shared Buffers

On Mon, Mar 2, 2009 at 1:31 PM, Ashish Karalkar wrote: > Take a look at > > http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf > > http://postgresql.mirrors-r-us.net/files/documentation/books/aw_pgsql/hw_performance/node3.html Wouldn't it be nice, to have any presentation's

Re: [GENERAL] Shared Buffers

Siddharth Shah wrote: Hello All, How Postgres Maintains data in Shared Buffer Does It maintains queried data in memory or table data and Next time how postgres fetch data from memory rather than disk Which algorithm is used for storing data how data is indexed in shared buffers Thanks Sidd

[GENERAL] Shared Buffers

Hello All, How Postgres Maintains data in Shared Buffer Does It maintains queried data in memory or table data and Next time how postgres fetch data from memory rather than disk Which algorithm is used for storing data how data is indexed in shared buffers Thanks Siddharth

Re: [GENERAL] Shared buffers

Note that starting in 8.0/8.1, you can sometimes get very large gains by setting shared_buffers very high; 1/2 of memory or more. On Jul 27, 2006, at 4:00 PM, Shoaib Mir wrote: Go to http://www.powerpostgresql.com/PerfList/ and see the shared_buffers settings section there. Thanks, -- Shoa

Re: [GENERAL] Shared buffers

Go to http://www.powerpostgresql.com/PerfList/ and see the shared_buffers settings section there.Thanks,-- Shoaib MirEnterpriseDB ( www.enterprisedb.com)On 7/27/06, Christian Rengstl <[EMAIL PROTECTED] > wrote:Hi list,just wanted to ask what is a "good/reasonable" value for the shared_bufferes vari

[GENERAL] Shared buffers

Hi list, just wanted to ask what is a "good/reasonable" value for the shared_bufferes variable. Right now i set it to 64000 on a windows 2003 server with 1GB ram and 3.2 GHz which runs as file server (for only a small number of users) and db server. Thanks -- Christian Rengstl M.A. Klinik und

Re: [GENERAL] shared buffers

Glenn Sullivan <[EMAIL PROTECTED]> writes: > What is the performance issue with setting shared_buffers to something like 45? > In doing some timing on my system, I cannot tell any difference with 45 versus 1000. What are you timing exactly? Almost every benchmark I've ever seen is much happier wi

[GENERAL] shared buffers

Hi, In the 7.4.5 version, the code is now trying to use a much larger value for shared_buffers. I can certainly set this to a lower number with the -B option. However, my guestion is: What is the performance issue with setting shared_buffers to something like 45? In doing some timing on my system