Re: VACUUM ANALYZE blocking both reads and writes to a table

Список
Период
Сортировка
От Alvaro Herrera
Тема Re: VACUUM ANALYZE blocking both reads and writes to a table
Дата
Msg-id 20080630190419.GC18252@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: VACUUM ANALYZE blocking both reads and writes to a table  (Tom Lane)
Ответы Re: VACUUM ANALYZE blocking both reads and writes to a table  (Peter Schuller)
Список pgsql-performance
Дерево обсуждения
VACUUM ANALYZE blocking both reads and writes to a table  (Peter Schuller, )
 Re: VACUUM ANALYZE blocking both reads and writes to a table  (Alvaro Herrera, )
  Re: VACUUM ANALYZE blocking both reads and writes to a table  (Peter Schuller, )
  Re: VACUUM ANALYZE blocking both reads and writes to a table  (Peter Schuller, )
   Re: VACUUM ANALYZE blocking both reads and writes to a table  (Alvaro Herrera, )
    Re: VACUUM ANALYZE blocking both reads and writes to a table  (Tom Lane, )
     Re: VACUUM ANALYZE blocking both reads and writes to a table  (Alvaro Herrera, )
      Re: VACUUM ANALYZE blocking both reads and writes to a table  (Peter Schuller, )
    Re: VACUUM ANALYZE blocking both reads and writes to a table  (Alvaro Herrera, )
Tom Lane wrote:

> (2) If it's autovacuum we're talking about, it will get kicked off the
> table if anyone else comes along and wants a conflicting lock.

Not on 8.2 though.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-performance по дате отправления:

Предыдущее
От: John Beaver
Дата:
Сообщение: Re: sequence scan problem
Следующее
От: "Emiliano Leporati"
Дата:
Сообщение: un-understood index performance behaviour