Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_stat_tmp file

pg_stat_tmp file

From
Rodrigo Barboza
Date:
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...

Re: pg_stat_tmp file

From
Magnus Hagander
Date:
On Fri, May 3, 2013 at 5:09 PM, Rodrigo Barboza <rodrigombufrj@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/

Re: pg_stat_tmp file

From
Rodrigo Barboza
Date:



On Mon, May 6, 2013 at 7:32 AM, Magnus Hagander <magnus@hagander.net> wrote:
On Fri, May 3, 2013 at 5:09 PM, Rodrigo Barboza <rodrigombufrj@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!!