Re: wal sync method

From: PFC
Subject: Re: wal sync method
Date: ,
Msg-id: op.s5qgvjilcigqcu@apollo13
(view: Whole thread, Raw)
In response to: Re: wal sync method  (Tom Lane)
List: pgsql-performance

Tree view

[HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Tom Lane, )
  Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  ("Kevin Grittner", )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
   Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
    Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
     Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
      Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
      Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
      Re: [HACKERS] A Better External Sort?  (Tom Lane, )
       Re: [HACKERS] A Better External Sort?  (Simon Riggs, )
       Re: [HACKERS] A Better External Sort?  (Greg Stark, )
       wal sync method  (Evgeny Gridasov, )
        Re: wal sync method  (Javier Somoza, )
         Re: wal sync method  (Bruce Momjian, )
          Re: wal sync method  (PFC, )
           Re: wal sync method  (Tom Lane, )
            Re: wal sync method  (PFC, )
     Re: [HACKERS] A Better External Sort?  (David Fetter, )
    Re: [HACKERS] A Better External Sort?  (Tom Lane, )
     Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
  Sequential I/O Cost (was Re: A Better External Sort?)  ("Jeffrey W. Baker", )
   Re: Sequential I/O Cost (was Re: A Better External Sort?)  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Gregory Maxwell, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Pailloncy Jean-Gerard, )
   Re: [HACKERS] A Better External Sort?  (PFC, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
   Re: [HACKERS] A Better External Sort?  (Michael Stone, )
    Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
     Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
      Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
       Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
       Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
        Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
       Re: [HACKERS] A Better External Sort?  (Hannu Krosing, )
        Re: [HACKERS] A Better External Sort?  (Michael Stone, )
     Re: [HACKERS] A Better External Sort?  (Michael Stone, )
   Re: [HACKERS] A Better External Sort?  (Simon Riggs, )
  Re: [HACKERS] A Better External Sort?  ("Jignesh K. Shah", )
  Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
   Re: [HACKERS] A Better External Sort?  (PFC, )
   Re: [HACKERS] A Better External Sort?  (Hannu Krosing, )
  Re: [HACKERS] A Better External Sort?  (Josh Berkus, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Gregory Maxwell, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Martijn van Oosterhout, )
   Re: [HACKERS] A Better External Sort?  (Michael Stone, )
  Re: [HACKERS] A Better External Sort?  (Andrew Dunstan, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Gregory Maxwell, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  ("Dann Corbit", )
 Re: [HACKERS] A Better External Sort?  ("Dann Corbit", )
 Re: [HACKERS] A Better External Sort?  ("Dann Corbit", )
 Re: [HACKERS] A Better External Sort?  ("Dann Corbit", )
 Re: [HACKERS] A Better External Sort?  ("Dann Corbit", )
 Re: [HACKERS] A Better External Sort?  ("Zeugswetter Andreas DAZ SD", )
  Re: [HACKERS] A Better External Sort?  ("Jim C. Nasby", )
 Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
  Re: [HACKERS] A Better External Sort?  (Michael Stone, )
   Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
    Re: [HACKERS] A Better External Sort?  ("Steinar H. Gunderson", )
     Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
      Re: [HACKERS] A Better External Sort?  (, )
       Re: [HACKERS] A Better External Sort?  ("Luke Lonergan", )
        Re: [HACKERS] A Better External Sort?  (, )
    Re: [HACKERS] A Better External Sort?  (Michael Stone, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  ("Joshua D. Drake", )
  Re: [HACKERS] A Better External Sort?  ("Jeffrey W. Baker", )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
 Re: [HACKERS] A Better External Sort?  (Ron Peacetree, )
  Re: [HACKERS] A Better External Sort?  (Tom Lane, )
   Re: [HACKERS] A Better External Sort?  (Alvaro Herrera <-ip.org>, )
  Re: [HACKERS] A Better External Sort?  (Tom Lane, )


    Hm, i seem to have mixed fwrite() (which buffers data in userspace) and
write() (which apparently doesnt !)
    Sorry !

> PFC <> writes:
>>     Just a stupid question about the various fsync settings.
>>     There is fsync=off, but is there fsync=fflush ?
>>     fflush would mean only an OS crash could cause data loss,
>>     I think.it could be useful for some applications where you need a speed
>> boost (like testing database import scripts...) without being as scary
>> as
>> fsync=off...
>
> I think you misunderstand.  There aren't any scenarios where a PG crash
> (without hardware/OS crash) risks data, because we always at least
> write() data before commit.  The only issue is how hard do we try to get
> the OS+hardware to push that data down to disk.
>
>             regards, tom lane




pgsql-performance by date:

From: PFC
Date:
Subject: Re: Bad plan on a view
From: Robert Treat
Date:
Subject: Re: Looking for a tool to "*" pg tables as ERDs