Thread: flush buffer after connection disllowed

flush buffer after connection disllowed

From
张柏年
Date:
Hi All,

      If there is command to flush the internal buffer  within Postgresql server of specific database  after all connections has been disconnected to that database?

Regards,
Emmett 

flush buffer after connection disallowed

Re: flush buffer after connection disllowed

From
Craig Ringer
Date:
On 11/20/2012 06:09 PM, 张柏年 wrote:
> Hi All,
>
>       If there is command to flush the internal buffer  within
> Postgresql server of specific database  after all connections has been
> disconnected to that database?
>

Why?

It isn't clear what problem you are trying to solve.

The write buffers and WAL are global across the cluster (group of
databases), they're not per-database. So you can't really flush just one
database as far as I know.

You shouldn't generally need to do any kind of explicit flushing anyway.
That's why a commit fsync()s.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services