Re: Weird XFS WAL problem

От: Kevin Grittner
Тема: Re: Weird XFS WAL problem
Дата: ,
Msg-id: 4C07C3AF0200002500031EC4@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Weird XFS WAL problem  (Greg Smith)
Список: 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, )

Greg Smith <> wrote:

> I think this can only be resolved usefully for all of us at the
> RAID firmware level.  If the controller had some logic that said
> "it's OK to not flush the cache when that call comes in if my
> battery is working fine", that would make this whole problem go
> away.

That is exactly what I've been trying to suggest.  Sorry for not
being more clear about it.

-Kevin


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

От: Anj Adu
Дата:
Сообщение: slow query
От: Yogesh Naik
Дата:
Сообщение: Performance tuning for postgres