Re: Create and drop temp table in 8.3.4

От: Kevin Grittner
Тема: Re: Create and drop temp table in 8.3.4
Дата: ,
Msg-id: 4912EAFF.EE98.0025.0@wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Create and drop temp table in 8.3.4  ("Kevin Grittner")
Ответы: Re: Create and drop temp table in 8.3.4  ("Joshua D. Drake")
Список: pgsql-performance

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

Create and drop temp table in 8.3.4  ("Kevin Grittner", )
 Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
 Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
  Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
   Re: Create and drop temp table in 8.3.4  ("Joshua D. Drake", )
    Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
     Re: Create and drop temp table in 8.3.4  ("Scott Carey", )
      Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
      Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
       Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
        Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
         Re: Create and drop temp table in 8.3.4  ("Kevin Grittner", )
          Re: Create and drop temp table in 8.3.4  ("Scott Marlowe", )
           Re: Create and drop temp table in 8.3.4  ("David Rees", )
           Re: Create and drop temp table in 8.3.4  (Matthew Wakeling, )
    Re: Create and drop temp table in 8.3.4  (Aidan Van Dyk, )
 Re: Create and drop temp table in 8.3.4  (Tom Lane, )

>>> "Kevin Grittner" <> wrote:
> If I find a particular tweak to the background writer or some such
is
> particularly beneficial, I'll post again.

It turns out that it was not the PostgreSQL version which was
primarily responsible for the performance difference.  We updated the
kernel at the same time we rolled out 8.3.4, and the new kernel
defaulted to using write barriers, while the old kernel didn't.  Since
we have a BBU RAID controller, we will add nobarrier to the fstab
entries.  This makes file creation and unlink each about 20 times
faster.

-Kevin


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

От: "Scott Marlowe"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4
От: "David Rees"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4