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