Re: flush buffer after connection disllowed

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