Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Дата
Msg-id CAFcNs+p_DSWB9ffMpEtFPrVf1Q7vV9+_ZA=tXfvJnrK3sufSuA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers


Em quinta-feira, 29 de janeiro de 2015, Pavel Stehule <pavel.stehule@gmail.com> escreveu:
Hi

I am testing this feature on relative complex schema (38619 tables in db) and I got deadlock

[pavel@localhost bin]$ /usr/local/pgsql/bin/vacuumdb test2 -fz -j 4
vacuumdb: vacuuming database "test2"
vacuumdb: vacuuming of database "test2" failed: ERROR:  deadlock detected
DETAIL:  Process 24689 waits for RowExclusiveLock on relation 2608 of database 194769; blocked by process 24690.
Process 24690 waits for AccessShareLock on relation 1249 of database 194769; blocked by process 24689.
HINT:  See server log for query details.

ERROR:  deadlock detected
DETAIL:  Process 24689 waits for RowExclusiveLock on relation 2608 of database 194769; blocked by process 24690.
        Process 24690 waits for AccessShareLock on relation 1249 of database 194769; blocked by process 24689.
        Process 24689: VACUUM (FULL, ANALYZE) pg_catalog.pg_attribute;
        Process 24690: VACUUM (FULL, ANALYZE) pg_catalog.pg_depend;
HINT:  See server log for query details.
STATEMENT:  VACUUM (FULL, ANALYZE) pg_catalog.pg_attribute;
ERROR:  canceling statement due to user request
STATEMENT:  VACUUM (FULL, ANALYZE) pg_catalog.pg_depend;
ERROR:  canceling statement due to user request
STATEMENT:  VACUUM (FULL, ANALYZE) pg_catalog.pg_class;
ERROR:  canceling statement due to user request
STATEMENT:  VACUUM (FULL, ANALYZE) pg_catalog.pg_proc;
LOG:  could not send data to client: Broken pipe
STATEMENT:  VACUUM (FULL, ANALYZE) pg_catalog.pg_proc;
FATAL:  connection to client lost
LOG:  could not send data to client: Broken pipe
ERROR:  canceling statement due to user request
FATAL:  connection to client lost

   Schema   |          Name           | Type  |  Owner   |    Size    | Description
------------+-------------------------+-------+----------+------------+-------------
 pg_catalog | pg_attribute            | table | postgres | 439 MB     |
 pg_catalog | pg_rewrite              | table | postgres | 314 MB     |
 pg_catalog | pg_proc                 | table | postgres | 136 MB     |
 pg_catalog | pg_depend               | table | postgres | 133 MB     |
 pg_catalog | pg_class                | table | postgres | 69 MB      |
 pg_catalog | pg_attrdef              | table | postgres | 55 MB      |
 pg_catalog | pg_trigger              | table | postgres | 47 MB      |
 pg_catalog | pg_type                 | table | postgres | 31 MB      |
 pg_catalog | pg_description          | table | postgres | 23 MB      |
 pg_catalog | pg_index                | table | postgres | 20 MB      |
 pg_catalog | pg_constraint           | table | postgres | 17 MB      |
 pg_catalog | pg_shdepend             | table | postgres | 17 MB      |
 pg_catalog | pg_statistic            | table | postgres | 928 kB     |
 pg_catalog | pg_operator             | table | postgres | 552 kB     |
 pg_catalog | pg_collation            | table | postgres | 232 kB     |


 
There are a warning in the docs to be careful to use the -f (full) option and -j.

Regards,

Fabrízio 
 


--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL

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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: Possible typo in create_policy.sgml
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]