Re: ??: Postgresql update op is very very slow

От: Holger Hoffstaette
Тема: Re: ??: Postgresql update op is very very slow
Дата: ,
Msg-id: pan.2008.06.26.12.40.59.151500@wizards.de
(см: обсуждение, исходный текст)
Ответ на: Re: Postgresql is very slow  (bijayant kumar)
Ответы: Re: ??: Postgresql update op is very very slow  (Craig Ringer)
Re: ??: Postgresql update op is very very slow  (Andrew Sullivan)
Re: ??: Postgresql update op is very very slow  (Mark Mielke)
Re: ??: Postgresql update op is very very slow  (Greg Smith)
Список: pgsql-performance

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

Postgresql is very slow  (bijayant kumar, )
 Re: Postgresql is very slow  (Jan de Visser, )
 Re: Postgresql is very slow  (Jeremy Harris, )
 Re: Postgresql is very slow  (, )
  Re: Postgresql is very slow  (bijayant kumar, )
   Re: Postgresql is very slow  ("Scott Marlowe", )
    Re: Postgresql is very slow  ("Scott Marlowe", )
    Re: Postgresql is very slow  (, )
     Re: Postgresql is very slow  (bijayant kumar, )
      Re: Postgresql is very slow  (, )
       Re: Postgresql is very slow  (bijayant kumar, )
       Re: [SOLVED] Postgresql is very slow  (bijayant kumar, )
      Re: Postgresql is very slow  (PFC, )
       Postgresql update op is very very slow  ("jay", )
        Re: Postgresql update op is very very slow  (Rusty Conover, )
         答复: [PERFORM] Postgresql update op is very very slow  ("jay", )
          PostgreSQL and Ruby on Rails - better accessibility  ("Amol Pujari", )
           Re: PostgreSQL and Ruby on Rails - better accessibility  (Nikhils, )
        Re: Postgresql update op is very very slow  ("Heikki Linnakangas", )
         答复: [PERFORM] Postgresql update op is very very slow  ("jay", )
          Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Pavan Deolasee", )
           Re: [PERFORM] Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Scott Marlowe", )
          Re: ??: Postgresql update op is very very slow  ("Heikki Linnakangas", )
          Re: 答复: [PERFORM] Postgresql update op is very very slow  (Tom Lane, )
           Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Scott Marlowe", )
        Re: Postgresql update op is very very slow  (Greg Smith, )
      Re: ??: Postgresql update op is very very slow  ("Holger Hoffstaette", )
       Re: ??: Postgresql update op is very very slow  (Craig Ringer, )
        Re: ??: Postgresql update op is very very slow  (Andrew Sullivan, )
        Re: ??: Postgresql update op is very very slow  (Greg Smith, )
       Re: ??: Postgresql update op is very very slow  (Andrew Sullivan, )
       Re: ??: Postgresql update op is very very slow  (Mark Mielke, )
       Re: ??: Postgresql update op is very very slow  (Greg Smith, )
    Re: Postgresql is very slow  ("Ian Barwick", )
 Re: Postgresql is very slow  ("Gregory S. Youngblood", )

Hi -

I have been following this thread and find some of the recommendations
really surprising. I understand that MVCC necessarily creates overhead,
in-place updates would not be safe against crashes etc. but have a hard
time believing that this is such a huge problem for RDBMS in 2008. How do
large databases treat mass updates? AFAIK both DB2 and Oracle use MVCC
(maybe a different kind?) as well, but I cannot believe that large updates
still pose such big problems.
Are there no options (algorithms) for adaptively choosing different
update strategies that do not incur the full MVCC overhead?

Holger

(Disclaimer: I'm not a professional DBA, just a curious developer).



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

От: "Merlin Moncure"
Дата:
Сообщение: Re: Hardware vs Software RAID
От: "Peter T. Breuer"
Дата:
Сообщение: Re: Hardware vs Software Raid