Re: Autovacuum / full vacuum

От: Mindaugas
Тема: Re: Autovacuum / full vacuum
Дата: ,
Msg-id: 034701c61c46$f427df20$f20214ac@bite.lt
(см: обсуждение, исходный текст)
Ответ на: Autovacuum / full vacuum  (Michael Riess)
Ответы: Re: Autovacuum / full vacuum  (Alvaro Herrera <-ip.org>)
Список: pgsql-performance

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

Autovacuum / full vacuum  (Michael Riess, )
 Re: Autovacuum / full vacuum  (Christopher Kings-Lynne, )
  Re: Autovacuum / full vacuum  (Michael Riess, )
   Re: Autovacuum / full vacuum  (Michael Stone, )
   Re: Autovacuum / full vacuum  ("Matthew T. O'Connor", )
    Re: Autovacuum / full vacuum  (Markus Schaber, )
    Re: Autovacuum / full vacuum  (Michael Riess, )
     Re: Autovacuum / full vacuum  (Tom Lane, )
     Re: Autovacuum / full vacuum  (Markus Schaber, )
    Re: Autovacuum / full vacuum  (Andrew Sullivan, )
  Re: Autovacuum / full vacuum  (Pandurangan R S, )
 Re: Autovacuum / full vacuum  (Alvaro Herrera <-ip.org>, )
 Re: Autovacuum / full vacuum  (Christopher Browne, )
  Re: Autovacuum / full vacuum  (Michael Riess, )
   Re: Autovacuum / full vacuum  (Andrew Sullivan, )
 Re: Autovacuum / full vacuum  ("Larry Rosenman", )
 Re: Autovacuum / full vacuum  (Christopher Browne, )
  Re: Autovacuum / full vacuum  (Michael Riess, )
   Re: Autovacuum / full vacuum  (Michael Stone, )
   Re: Autovacuum / full vacuum  (Andrew Sullivan, )
    Re: Autovacuum / full vacuum  (Scott Marlowe, )
     Re: Autovacuum / full vacuum  (Andrew Sullivan, )
      Re: Autovacuum / full vacuum  (Scott Marlowe, )
   Re: Autovacuum / full vacuum  (hubert depesz lubaczewski, )
   Re: Autovacuum / full vacuum  ("Jim C. Nasby", )
    Re: Autovacuum / full vacuum  (Michael Riess, )
     Re: Autovacuum / full vacuum  ("Jim C. Nasby", )
 Re: Autovacuum / full vacuum  (Andrew Sullivan, )
  Re: Autovacuum / full vacuum  (Michael Riess, )
   Re: Autovacuum / full vacuum  (Andrew Sullivan, )
 Re: Autovacuum / full vacuum  (Tom Lane, )
 Re: Autovacuum / full vacuum  (Chris Browne, )
  Re: Autovacuum / full vacuum  (Alvaro Herrera <-ip.org>, )
  Re: Autovacuum / full vacuum  (Andrew Sullivan, )
 Re: Autovacuum / full vacuum  (Chris Browne, )
  Re: Autovacuum / full vacuum  (Tom Lane, )
 Re: Autovacuum / full vacuum  ("Mindaugas", )
  Re: Autovacuum / full vacuum  (Alvaro Herrera <-ip.org>, )
 Re: Autovacuum / full vacuum  (Chris Browne, )
  Re: Autovacuum / full vacuum (off-topic?)  (Michael Crozier, )
   Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )
    Re: Autovacuum / full vacuum (off-topic?)  (Michael Crozier, )
     Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )
    Re: Autovacuum / full vacuum (off-topic?)  (Mark Kirkwood, )
     Re: Autovacuum / full vacuum (off-topic?)  (Bruce Momjian, )
     Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )
      Re: Autovacuum / full vacuum (off-topic?)  ("Joshua D. Drake", )
       Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )
        Re: Autovacuum / full vacuum (off-topic?)  ("Joshua D. Drake", )
         Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )
 Re: Autovacuum / full vacuum (off-topic?)  (Chris Browne, )
  Re: Autovacuum / full vacuum (off-topic?)  (Michael Crozier, )
 Re: Autovacuum / full vacuum (off-topic?)  (<>, )
  Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby", )

> >> Even a database-wide vacuum does not take locks on more than one table.
> >> The table locks are acquired and released one by one, as the operation
> >> proceeds.
>
> > Has that changed recently?  I have always seen "vacuumdb" or SQL
> > "VACUUM" (without table specifications) running as one long
> > transaction which doesn't release the locks that it is granted until
> > the end of the transaction.
>
> You sure?  It's not supposed to, and watching a database-wide vacuum
> with "select * from pg_locks" doesn't look to me like it ever has locks
> on more than one table (plus the table's indexes and toast table).

  Are there some plans to remove vacuum altogether?

  Mindaugas



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

От: Michael Fuhr
Дата:
Сообщение: Re: Use of Stored Procedures and
От: William Yu
Дата:
Сообщение: Re: 3WARE Card performance boost?