Hello!
Do you know which could be the reasons that could conduce an application to
not release the shared buffers, even after the application was shut down?
I noticed that only if a pg_ctl restart command is issued some of the
buffers are set free.
Thank you very much
With best regards,
Sorin
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>:
>
> Hello!
>
> Do you know which could be the reasons that could conduce an application to
> not release the shared buffers, even after the application was shut down?
> I noticed that only if a pg_ctl restart command is issued some of the
On Wednesday 25 April 2007 11:28, Pascal Robert wrote:
> Hi,
>
> I'm writing our backup procedure for using WAL and PITR, but to be
> able to do a (mostly) perfect PITR, I need to find the time when a
> error (DELETE FROM, DROP TABLE, etc.) was made so that I can do a
> restore just before the erro
I don't know the algorithm on which Postgre uses the shared buffers but I'd
like to find the principles behind it. Let's assume the following scenario:
I've set shared_buffers=3000
At the starting of Postgres there are 115 buffers used by database A
After the execution of some processing caused by
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>:
>
> I don't know the algorithm on which Postgre uses the shared buffers but I'd
> like to find the principles behind it. Let's assume the following scenario:
> I've set shared_buffers=3000
> At the starting of Postgres there are 115 buffers u
