Re: pg_stat_tmp file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux