Обсуждение: pg_stat_tmp file

Поиск
Список
Период
Сортировка

pg_stat_tmp file

От
Rodrigo Barboza
Дата:
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

От
Magnus Hagander
Дата:
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

От
Rodrigo Barboza
Дата:



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!!