Jeff Janes wrote > On Tuesday, August 12, 2014, pinker < > pinker@ > > wrote: > >> Do you ever plan on restarting this server? Doing maintenance? Applying >> security patches? > > Sure, I assumed when db is up and running, of course after first read from > disk when whole data should be in RAM. > > >> More like b), but you are missing all the states that involve "clean in >> shared_buffers, dirty in FS cache" and such. > > Ok, so modified block is taken from shared_buffers or from RAM when > needed, and is readed always from shared buffers? > > >> >> btw. 512MB if we assume up to 600 connection is a reasonable value? >> > >>Reasonable value for what? > > For normal server load. > > Cheers, > > Jeff -- View this message in context: http://postgresql.1045698.n5.nabble.com/Database-block-lifecycle-tp5814627p5814672.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
