On Tue, Aug 6, 2013 at 12:37 AM, Vlad Arkhipov <arhi...@dc.baikal.ru> wrote: >> What pgstattuple shows on this table? >> http://www.postgresql.org/docs/9.2/interactive/pgstattuple.html >> > > dcdb=# select * from pgstattuple('pg_catalog.pg_attribute'); > table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | > dead_tuple_len | dead_tuple_percent | free_space | free_percent > ------------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- > 6363938816 | 48786 | 6830040 | 0.11 | 1459439 | > 204321460 | 3.21 | 5939017376 | 93.32 > (1 row)
I guess you need to VACUUM FULL pg_attribute, if it is possible in your situation of course. If it is not, let me know, I have another one tricky way of solving this problem in my mind. -- 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...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
