On Mon, May 6, 2013 at 7:32 AM, Magnus Hagander <mag...@hagander.net> wrote:
> 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/ > Ok, thanks!!
