Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
От
Simon Riggs
Тема
Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Дата
Msg-id
BANLkTim6ucpFuytq=kf2ignxFUeUK2N=1Q@mail.gmail.com
Ответ на
Re: Can we Flush the Postgres Shared Memory ? (raghu ram)
Список
Дерево обсуждения
Can we Flush the Postgres Shared Memory ? raghu ram <raghuchennuru@gmail.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Simon Riggs <simon@2ndQuadrant.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Raghavendra <raghavendra.rao@enterprisedb.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? raghu ram <raghuchennuru@gmail.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Simon Riggs <simon@2ndQuadrant.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Merlin Moncure <mmoncure@gmail.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Merlin Moncure <mmoncure@gmail.com>
Re: [ADMIN] Can we Flush the Postgres Shared Memory ? Cédric Villemain <cedric.villemain.debian@gmail.com>
On Tue, May 3, 2011 at 2:30 PM, raghu ram wrote: >>> The CHECKPOINT command will do this for you. >> >> > > According to PostgreSQL documentation, whenever you execute "CHECKPOINT" in > the database,it will flush the modified data files presented in the Shared > Buffers retuned to the Disk. > http://www.postgresql.org/docs/9.0/static/sql-checkpoint.html > Is this clears the entire shared memory cache and same time,if i execute > fresh SQL statement, Data will be retuned from disk?? No, but then you'd need to flush OS buffers and all disk caches as well to make that effective. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-general по дате отправления
