Re: Create and drop temp table in 8.3.4

От: Kevin Grittner
Тема: Re: Create and drop temp table in 8.3.4
Дата: ,
Msg-id: 49131C67.EE98.0025.0@wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Create and drop temp table in 8.3.4  ("Scott Marlowe")
Ответы: Re: Create and drop temp table in 8.3.4  ("Scott Marlowe")
Список: 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, )

>>> "Scott Marlowe" <> wrote:
> I am pretty sure that with no write barriers that even a BBU
hardware
> caching raid controller cannot guarantee your data.

That seems at odds with this:

http://oss.sgi.com/projects/xfs/faq.html#wcache_persistent

What evidence to you have that the SGI XFS team is wrong?

It does seem fairly bizarre to me that we can't configure our system
to enforce write barriers within the OS and file system without having
it enforced all the way past the BBU RAID cache onto the hard drives
themselves.  We consider that once it hits the battery-backed cache,
it is persisted.  Reality has only contradicted that once so far (with
a RAID controller failure), and our backups have gotten us past that
with no sweat.

-Kevin


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

От: "David Rees"
Дата:
Сообщение: Re: Create and drop temp table in 8.3.4
От: "Віталій Тимчишин"
Дата:
Сообщение: Re: PostgreSQL OR performance