От: Tom Lane
Тема: Re: PG8 Tuning
Дата: ,
Msg-id: 10092.1124245640@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: PG8 Tuning  (John A Meinel)
Список: pgsql-performance

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

PG8 Tuning  ("Paul Johnson", )
 Re: PG8 Tuning  (Richard Huxton, )
 [SPAM?] Re: PG8 Tuning  (Steve Poe, )
  Re: [SPAM?] Re: PG8 Tuning  ("Jeffrey W. Baker", )
   Re: [SPAM?] Re: PG8 Tuning  (Jeff Trout, )
   Re: [SPAM?] Re: PG8 Tuning  (Josh Berkus, )
    Re: [SPAM?] Re: PG8 Tuning  (Alvaro Herrera <-ip.org>, )
     Re: [SPAM?] Re: PG8 Tuning  ("Joshua D. Drake", )
     Re: PG8 Tuning  (John A Meinel, )
      Re: PG8 Tuning  (Tom Lane, )
       Re: PG8 Tuning  (John A Meinel, )
        Re: PG8 Tuning  (Tom Lane, )
    Re: [SPAM?] Re: PG8 Tuning  (Michael Stone, )
     Re: PG8 Tuning  (Josh Berkus, )
  Re: [SPAM?] Re: PG8 Tuning  (Tom Arthurs, )
  Re: PG8 Tuning  (Mark Lewis, )
   Re: PG8 Tuning  (Michael Stone, )
 Re: PG8 Tuning  (Michael Stone, )
 Re: PG8 Tuning  ("Merlin Moncure", )

John A Meinel <> writes:
> So pg_xlog is really only needed for a dirty shutdown. So what about the
> idea of having pg_xlog on a ramdisk that is syncronized periodically to
> a real disk.

Well, if "periodically" means "at every transaction commit", that's
pretty much what we do now.

            regards, tom lane


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

От: mudfoot@rawbw.com
Дата:
Сообщение: Re: Performance problem using V3 protocol in jdbc driver
От: Ulrich Wisser
Дата:
Сообщение: Re: Need for speed