On Fri, May 3, 2013 at 5:09 PM, Rodrigo Barboza <rodrigombu...@gmail.com> wrote: > Hi, guys. > Postgres doc says it is better to place the pgstat.stat file in ram disk. > And it says that at shutdown, it is copied to global. > What happens if postgres do not shutdown the usual way? > If machine loses power, for example...
PostgreSQL always discards the statistics file on an unclean shutdown, such as a powerloss, regardless of where it's stored. Therefor, it's not a problem that it's stored on a ramdrive. This is because it cannot be guaranteed to be consistent in that case. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
