Re: System catalog vacuum issues
| От | Sergey Konoplev |
|---|---|
| Тема | Re: System catalog vacuum issues |
| Дата | |
| Msg-id | CAL_0b1t+J6i2zk1-rf2NUqyuwDZbX5QbOf0X2pL2ZvLKLW6YUg@mail.gmail.com обсуждение исходный текст |
| Ответ на | System catalog vacuum issues (Vlad Arkhipov <arhipov@dc.baikal.ru>) |
| Ответы |
Re: System catalog vacuum issues
|
| Список | pgsql-hackers |
On Mon, Aug 5, 2013 at 10:56 PM, Vlad Arkhipov <arhipov@dc.baikal.ru> wrote: > dcdb=# select relname, n_live_tup, n_dead_tup, last_vacuum, last_autovacuum > from pg_stat_sys_tables where relname = 'pg_attribute'; > relname | n_live_tup | n_dead_tup | last_vacuum | > last_autovacuum > --------------+------------+------------+-------------------------------+------------------------------- > pg_attribute | 39318086 | 395478 | 2013-08-06 14:47:48.187259+09 | > 2013-08-06 13:43:03.162286+09 What pgstattuple shows on this table? http://www.postgresql.org/docs/9.2/interactive/pgstattuple.html -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@gmail.com
В списке pgsql-hackers по дате отправления: