Обсуждение: pg_stat_tmp file
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...
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/
On Mon, May 6, 2013 at 7:32 AM, Magnus Hagander <magnus@hagander.net> wrote:
PostgreSQL always discards the statistics file on an unclean shutdown,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...
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!!