Re: [ADMIN] Can we Flush the Postgres Shared Memory ?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Дата
Msg-id BANLkTi=VtowCtuQTmjmnTiEk7mYAY8X2dw@mail.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 ?  (raghu ram <raghuchennuru@gmail.com>)
Список pgsql-novice

On Tue, May 3, 2011 at 5:37 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Tue, May 3, 2011 at 11:54 AM, raghu ram <raghuchennuru@gmail.com> wrote:

> It may be a silly question, still out of curiosity I want to know, is there
> any possible way to flush the Postgres Shared Memory without restarting the
> cluster.
> In Oracle, we can flush the SGA, can we get the same feature here..
> Thanks in Advance.


The CHECKPOINT command will do this for you.

This command will empty the PSM...

Best Regards,
Raghavendra
EnterpriseDB Corporation


В списке pgsql-novice по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Следующее
От: raghu ram
Дата:
Сообщение: Re: [ADMIN] Can we Flush the Postgres Shared Memory ?