Re: pg_stat_tmp file

On Mon, May 6, 2013 at 7:32 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> On Fri, May 3, 2013 at 5:09 PM, Rodrigo Barboza <rodrigombufrj(at)gmail(dot)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!!