Re: compact flash disks?

От: Magnus Hagander
Тема: Re: compact flash disks?
Дата: ,
Msg-id: 20070308084823.GA7216@svr2.hagander.net
(см: обсуждение, исходный текст)
Ответ на: Re: compact flash disks?  ("James Mansion")
Ответы: Re: compact flash disks?  ("Merlin Moncure")
Re: compact flash disks?  ("James Mansion")
Список: pgsql-performance

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

compact flash disks?  ("James Mansion", )
 Re: compact flash disks?  ("Merlin Moncure", )
 Re: compact flash disks?  (Florian Weimer, )
 Re: compact flash disks?  (Ron, )
  Re: compact flash disks?  (Carlos Moreno, )
   Re: compact flash disks?  (Csaba Nagy, )
    Re: compact flash disks?  ("James Mansion", )
     postgresql.conf file for PostgreSQL 8.2.3  (Eugene Ogurtsov, )
  Re: compact flash disks?  ("James Mansion", )
   Re: compact flash disks?  (Magnus Hagander, )
    Re: compact flash disks?  ("Merlin Moncure", )
    Re: compact flash disks?  ("James Mansion", )
  Re: compact flash disks?  (Ron, )
   Re: compact flash disks?  ("Merlin Moncure", )
    Question about PGSQL functions  (Steve, )
     Re: Question about PGSQL functions  (Heikki Linnakangas, )
      Re: Question about PGSQL functions  (Steve, )
 Re: compact flash disks?  (cedric, )

On Thu, Mar 08, 2007 at 06:24:35AM -0000, James Mansion wrote:
>
> In the long run, we are going to have to seriously rethink pg's use
> of WAL as the way we implement MVCC as it becomes more and more of a
> performance bottleneck.
> We have WAL because Stonebreaker made an assumption about the future
> dominance of optical media that has turned out to be false.
> ...and it's been one of pg's big issues every since.

Uh. pg didn't *have* WAL back when Stonebreaker was working on it. It
was added in PostgreSQL 7.1, by Vadim. And it significantly increased
performance at the time, since we no longer had to sync the datafiles
after every transaction commit.
(We also didn't have MVCC back in the Stonebreaker days - it was added
in 6.5)

That said, it's certainly possible that someone can find an even better
way to do it :-)

//Magnus


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

От: "Merlin Moncure"
Дата:
Сообщение: Re: compact flash disks?
От: Jeff Cole
Дата:
Сообщение: Re: