Re: Weird XFS WAL problem

От: Kevin Grittner
Тема: Re: Weird XFS WAL problem
Дата: ,
Msg-id: 4C07B9780200002500031EBB@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Weird XFS WAL problem  (Scott Marlowe)
Список: pgsql-performance

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

Random Page Cost and Planner  (David Jarvis, )
 Re: Random Page Cost and Planner  (David Jarvis, )
 Re: Random Page Cost and Planner  ("Kevin Grittner", )
  Re: Random Page Cost and Planner  (David Jarvis, )
   Re: Random Page Cost and Planner  (Tom Lane, )
    Re: Random Page Cost and Planner  (David Jarvis, )
     Re: Random Page Cost and Planner  (Alexey Klyukin, )
      Re: Random Page Cost and Planner  (David Jarvis, )
   Re: Random Page Cost and Planner  (Rob Wultsch, )
    Re: Random Page Cost and Planner  (David Jarvis, )
     Re: Random Page Cost and Planner  (, )
   Re: Random Page Cost and Planner  ("Kevin Grittner", )
    Re: Random Page Cost and Planner  (David Jarvis, )
     Re: Random Page Cost and Planner  (David Jarvis, )
 Re: Random Page Cost and Planner  (, )
  Re: Random Page Cost and Planner  (David Jarvis, )
 Re: Random Page Cost and Planner  (David Jarvis, )
  Re: Random Page Cost and Planner  (Cédric Villemain, )
   Re: Random Page Cost and Planner  (David Jarvis, )
    Re: Random Page Cost and Planner  (Cédric Villemain, )
     Weird XFS WAL problem  (Craig James, )
      Re: Weird XFS WAL problem  (Mark Kirkwood, )
       Re: Weird XFS WAL problem  (Craig James, )
        Re: Weird XFS WAL problem  (Matthew Wakeling, )
         Re: Weird XFS WAL problem  ("Kevin Grittner", )
          Re: Weird XFS WAL problem  (Greg Smith, )
           Re: Weird XFS WAL problem  ("Kevin Grittner", )
            Re: Weird XFS WAL problem  (Scott Marlowe, )
             Re: Weird XFS WAL problem  ("Kevin Grittner", )
             Re: Weird XFS WAL problem  (Greg Smith, )
              Re: Weird XFS WAL problem  (Scott Marlowe, )
              Re: Weird XFS WAL problem  ("Kevin Grittner", )
              Re: Weird XFS WAL problem  (Matthew Wakeling, )
           Re: Weird XFS WAL problem  (Bruce Momjian, )
            Re: Weird XFS WAL problem  ("Kevin Grittner", )
             Re: Weird XFS WAL problem  (Bruce Momjian, )
              Re: Weird XFS WAL problem  ("Kevin Grittner", )
               Re: Weird XFS WAL problem  (Bruce Momjian, )
                Re: Weird XFS WAL problem  ("Kevin Grittner", )
                 Re: Weird XFS WAL problem  (Bruce Momjian, )
                 Re: Weird XFS WAL problem  (Greg Smith, )
                  Re: Weird XFS WAL problem  (Bruce Momjian, )
        Re: Weird XFS WAL problem  (Greg Smith, )
      Re: Weird XFS WAL problem  (Merlin Moncure, )
      Re: Weird XFS WAL problem  (Greg Smith, )
  Re: Random Page Cost and Planner  (Bryan Hinton, )
   Re: Random Page Cost and Planner  (David Jarvis, )

Scott Marlowe <> wrote:

> I think it's a case of the quickest, simplest answer to semi-new
> tech.  Not sure what to do with barriers?  Just flush the whole
> cache.
>
> I'm guessing that this will get optimized in the future.

Let's hope so.

That reminds me, the write barrier concept is at least on the
horizon as a viable technology; does anyone know if the asynchronous
graphs concept in this (one page) paper ever came to anything?  (I
haven't hear anything about it lately.)

http://www.usenix.org/events/fast05/wips/burnett.pdf

-Kevin


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

От: Cédric Villemain
Дата:
Сообщение: Re: How to insert a bulk of data with unique-violations very fast
От: Anj Adu
Дата:
Сообщение: slow query