Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute

Thanks for your help

I don't create and drop alot of tables.7
Here is my config
"version";"PostgreSQL 9.0.6, compiled by Visual C++ build 1500, 64-bit"
"autovacuum_analyze_threshold";"250"
"autovacuum_vacuum_threshold";"1000"
"bytea_output";"escape"
"checkpoint_segments";"64"
"client_encoding";"UNICODE"
"custom_variable_classes";"symmetric"
"effective_cache_size";"4GB"
"enable_seqscan";"off"
"extra_float_digits";"2"
"lc_collate";"English_United States.1252"
"lc_ctype";"English_United States.1252"
"listen_addresses";"*"
"log_destination";"stderr"
"log_line_prefix";"%t "
"logging_collector";"on"
"maintenance_work_mem";"1GB"
"max_connections";"100"
"max_locks_per_transaction";"2000"
"max_stack_depth";"2MB"
"max_wal_senders";"5"
"port";"5433"
"server_encoding";"UTF8"
"shared_buffers";"2GB"
"shared_preload_libraries";"$libdir/plugins/plugin_debugger.dll"
"TimeZone";"Asia/Bangkok"
"wal_buffers";"2MB"
"wal_keep_segments";"128"
"wal_level";"hot_standby"
"work_mem";"64MB"

Tuan Hoang Anh

On Fri, Jun 29, 2012 at 9:13 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> wrote:

> tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
>
> > VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type,
> > pg_catalog.pg_depend run all time of day.
> >
> > Is it normal in Postgres?
>
> Do you create and drop a lot of tables (including temporary tables)?
>
> What are the results of running the query on this page?:
>
> http://wiki.postgresql.org/wiki/Server_Configuration
>
> How is overall performance on the machine?
>
> -Kevin
>