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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
