Re: Weird XFS WAL problem

От: Mark Kirkwood
Тема: Re: Weird XFS WAL problem
Дата: ,
Msg-id: 4C06EC01.3060506@catalyst.net.nz
(см: обсуждение, исходный текст)
Ответ на: Weird XFS WAL problem  (Craig James)
Ответы: Re: Weird XFS WAL problem  (Craig James)
Список: 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, )

On 03/06/10 11:30, Craig James wrote:
> I'm testing/tuning a new midsize server and ran into an inexplicable
> problem.  With an RAID10 drive, when I move the WAL to a separate
> RAID1 drive, TPS drops from over 1200 to less than 90!   I've checked
> everything and can't find a reason.
>
>

Are the 2 new RAID1 disks the same make and model as the 12 RAID10 ones?

Also, are barriers *on* on the RAID1 mount and off on the RAID10 one?

Cheers

Mark



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

От: Joshua Tolley
Дата:
Сообщение: Re: requested shared memory size overflows size_t
От: Matthew Wakeling
Дата:
Сообщение: Re: SELECT ignoring index even though ORDER BY and LIMIT present