Search Postgresql Archives

Re: Too slow to create new schema and their tables, functions, triggers.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Correct, seems to be something wrong on system tables. Maybe our script is
running something is already there, we will check.

select * from pg_stat_sys_tables where schemaname = 'pg_catalog'

relname	         n_live_tup	n_dead_tup
pg_attrdef	            3699	     1095
pg_index	          4756	   1183
pg_sequence	  20827	  1482
pg_statistic	  171699	  27101
pg_trigger	          221319	 20718
pg_shdepend	   225017	  22337
pg_attribute	  883023	  164153
pg_depend	  1553586	  142960

and all them last_vacuum is null and last_autovacuum is too old.

So, is it better to configure autovacuum properly to these tables or should
I run vacuum periodically ?
Obviously I´ll check our script too.



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux