Re: extremly low memory usage

От: Michael Stone
Тема: Re: extremly low memory usage
Дата: ,
Msg-id: 20050820122305.GN19080@mathom.us
(см: обсуждение, исходный текст)
Ответ на: Re: extremly low memory usage  (Marko Ristola)
Ответы: Re: extremly low memory usage  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

extremly low memory usage  (Jeremiah Jahn, )
 Re: extremly low memory usage  (John A Meinel, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
 Re: extremly low memory usage  (Jeff Trout, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
    Re: extremly low memory usage  (Ron, )
    Re: extremly low memory usage  (Jeremiah Jahn, )
     Re: extremly low memory usage  (John A Meinel, )
      Re: extremly low memory usage  (Ron, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (John A Meinel, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
           Re: extremly low memory usage  (Ron, )
           Re: extremly low memory usage  (John A Meinel, )
         Re: extremly low memory usage  (Dan Harris, )
          Re: extremly low memory usage  (Marko Ristola, )
           Re: extremly low memory usage  (Michael Stone, )
            Re: extremly low memory usage  (Tom Lane, )
             Re: extremly low memory usage  (Marko Ristola, )
          Re: extremly low memory usage  (Michael Stone, )
      Re: extremly low memory usage  (Jeremiah Jahn, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (John A Meinel, )
           Re: extremly low memory usage  (Jeremiah Jahn, )
            Re: extremly low memory usage  (John A Meinel, )
            Re: extremly low memory usage  (Ron, )
             Re: extremly low memory usage  (William Yu, )
             Re: extremly low memory usage  (Jeremiah Jahn, )
              Re: extremly low memory usage  (John A Meinel, )
 Re: extremly low memory usage  (Ron, )
 Re: extremly low memory usage  (Ron, )

On Sat, Aug 20, 2005 at 02:17:54PM +0300, Marko Ristola wrote:
>Based on my knoledge, Ext3 is good with keeping filesystem integrity
>AND data integrity while pressing the reset button.  However, by
>selecting data=writeback, you gain more speed, but you risk the data
>integrity during a crash: Ext3 garantees only filesystem integrity.

That's why postgres keeps its own transaction log. Any of these
filesystems guarantee data integrity for data that's been synced to
disk, and postgres keeps track of what data has and has not been
committed so it can recover gracefully from a failure. That's why most
filesystems are designed the way they are; the application can determine
what things need better data integrity and which need better performance
on a case-by-case basis.

Mike Stone


В списке pgsql-performance по дате сообщения:

От: Jeremiah Jahn
Дата:
Сообщение: Re: extremly low memory usage
От: Jeremiah Jahn
Дата:
Сообщение: Re: extremly low memory usage